Microsoft Access Command Button

[pk17906]

How do you add a command button to a form to open another form based upon the id of the form.

I have a form (Quote) with tabs on it and one of the tabs are a list of parts for the particular quote. I want to be able to click on a command button and add a list of parts based on the quote_Id field.

 

[SydneyGeek]

IN Design view on the form, do this:
1. Make sure that the Wizards button on the Toolbox is activated.
2. Drag a button from the Toolbox to the form. The Wizard will launch.
3. From the list of options, select Open a Form
4. Next screen, pick Show Related (or is it Matching?) records
5. Match the Quote ID fields on both sides.
Next screen, give the button a caption.
Finish or OK, and you're done.
Resize and position as required.

Denis