View Full Version : Control Source or SetValue or Default Value


Nata
04-08-2001, 09:42 AM
I have a form that has a list of clients. I have another form that will record orders of clients.
So I want it so that when I click on New Order button it automatically records the ID of the client who places the order, so that it's attached to his record.
I have tried setting Default Value to ID from CLIENTS form, and setting Default Value to DLookup and then whatever (I'm not a coder, so I might have messed up there), then tried creating a macro and use SetValue, and nothing works.
Any ideas?

alxj
04-09-2001, 04:23 AM
I think that you are on slightly the wrong track.
Go back to the basics.
If you have a table with your clients in and a table for the orders to go into then relate the two tables together then use the form wizard to create a simple form with subform.
Use the example northwind database to help you.

Nata
04-09-2001, 05:15 AM
Thanks
But it won't let me. My form is set to Continous forms (and that's what I need it to be), and therefore it says I can't have a subform on continuous form.
So I'm looking for a workaround.
When I try to put subform on it it gives me that error message, and then still puts the form there. Property set to UNBOUND though.
So I don't know what that means, is it usable or no.

Nata
04-09-2001, 05:17 AM
But what you said about relating is good.

I already have both forms made. How can I connect them at this point to work with each other.