How to open a form from another form GOING TO THE CURRENT RECORD?

T

Thrust

Pushing a button from one form i want to open a second form going to the
relevant-current record. Reading help i see that i use the OpenForm action
(which opens my second form) but can't use correctly the SetValue action and
set the arguments. Please help.
 
S

Steve Schapel

Thrust,

No, you wouldn't use a SetValue action here. You would use the Where
Condition argument of the OpenForm action. It will look something like
this:
[YourPrimaryKeyField]=[Forms]![NameOfForm]![PrimaryKeyField]
 

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

Macro for form for collecting report parameters 21
The expression you used has a function name Access can't find 2
Using SetValue in sub-form macro 5
searchforrecord macro pulling wrong record 5
Access 2003 Access Error Form Name 0
Find Record action to display a record that is the current record on another for 0
Open subform to specific record 2
Access Command to run access, open to specific form and specific record 1

Top