Linked tables

B

Buz

Hi.
I have a Form for customers.
A form for Orders and a subform for Products.
In the Customers form I've put a command button to open the Orders form.
It asks if any of the field need to be linked so I made customerID in both
forms link up and then finished the wizard.
The button works and opens the Orders form but the customerID field is
empty.
I don't want the user to have to retype in the customers name.
Otherwise surely there's no point in putting in the open form command
button. You may as well close the customer form and open Orders form.
What am I missing here please!
 
B

Buz

I'll give it a go
Thanx

Klatuu said:
Easier than you might think. In Access, go into help, in Index tab,
search
for OpenArgs - It will give you all the info, including sample code, that
will do the trick for you.
Click to expand...
 

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

Form #1 that filters form #2 6
Using Access 2003 2
Automatically fill in customerID on Orders Subform 4
Command Button to open form to specific record 2
adding records to a form need a code or how to 1
OpenArgs Compile Error 13
How do I create mutiple orders in a subform linked to Customer ID? 2
Main Form updates Sub-Form and associated table? 1

Top