command buttons and filters

[battenberg]

Hi...total newbie here trying to get out of the blocks!

I want to be able to open forms with a button and filter in the process.

I have Customer details in a table
I have Site details in a table
I have Product details in a table

From my 'frmCustomer' I want to hit a comand button to open 'frmSite' and filter only the records related to that customer, then from my 'frmSites' hit a command button to open 'frmProducts' filterd by that site.

Please help, driving me mad!

 

[macca the hacke]

If you insert a command button onto your frmCustomers, it will open a wizard asking you what you want the button to do. If you select form operations, and open form, then select frmSite as the form to open. Then choose open the form and find specific data to filter for. You will then need to say what field to join in each table (ie customer id #).

 

[battenberg]

Hi, Thanks for the reply...

that's what i tried to do, but when i clicked it in run time, it came up with a dialogue box asking me 'Enter Parameter Value'

do I have something wrong with my relationships?

 

[macca the hacke]

Sorry what do you mean run time?? If you are only using MS Access Run Time you will not have the full functionality of a full version of Access. I do not know if you can add command buttons using MS Access Run Time

 

[battenberg]

appologies if my terminology is out!

thanks for the help, support and your time in answeing my questions

What I mean by 'run time' is when the program is actually running, not in design mode.

I have got to the bottom of it, and learning every day!!!

thank you all for the input!