Selecting a record on 1 form based on another form using a button

K

Knew2

Hi everyone
I am trying to set a button that runs off a macro on form1 that opens form2
and goes to the specific record that was selected on form1.

Here's the set-up:

Forms "IF_assignaccount" and "AF_projectstatus" are based on queries
(projectstatus has a preexisting filter from the query
(((AF_ProjectStatus.Closed=-1))) AND ((AF_ProjectStatus.Closed=-1))

The command button created on the "projectstatus" form was set to run the
following macro:

-openform
Name:IF_Assignaccount
View:Form
Filter
WhereCondition:[Forms]![AF_ProjectStatus]![ProjectAccessionNumber]=[Forms]![IF_AssignAccount]![ProjectAccessionNumber]
DataMode:
WindowMode:Normal
-MoveSize
-beep

When I excute the button, The form appears and is set at the correct
location and the system beeps. However, The form does not select the
specific record and has no data (structure, fields etc are all there, just no
data). I have tried adjusting different properties on form2 to get the
matched record to show up but no dice.

Any steerage would be helpful.....Thanks to all !!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting a record on 1 form based on another form using a button 2
Using combo box to select record source 1
use form from one mdb in another mdb 2
Update data in a form based on record selection in another subform 1
Go to a new record on another form? 6
Find Record on Another Form 3
Select record in one form and open it in another. 3
Click on Field in Form and Opens to Specific Record in Another Form 0

Top