Link to new form in Access 2003

[bladeuk]

Hi,

I have a command button on an input form that when clicked goes to a new form.

Problem is, it goes to the 1st record in the database as opposed to the ID number of the form I am currently in.

I want to click on this button and then the next form display the details for the ID on my initial input form. This second form is to complete a couple of new fields with instructions and be printed out.

I'm not too hot on expression builder and code, so the simpler the answer the better if possible.

I've tried to use the 'Where Condition' filed in my macro and followed waht I think is the correct route but it will still not work.

[Forms]![frmInputForm]![ID No]


Any advice/help gratefully appreciated.

Dave

 

[Norie]

Dave

How did you create the button?

The wizard should guide you through opening another form based on criteria of the current form.

In code the Where argument usually looks something like this, where ItemID is the common field and the name of it's control on the form.

"ItemID="& Me!ItemID

 

[bladeuk]

Thanks - You're right of course...If I had used the wizard properly - it would have done EXACTLY what I wanted.

many thanks

Dave