Form in a form

[aliceapraham]

I'm doing a form that has a subform in it from a table, then I want to put another table in that spasific form, how can i do that? cause when I'm puting a text box & in the control source I'm pressing the expression builder & clicking on the table that i want & the field that i want but it gives me an error, what is wrong with that picture. Can't i put 2 or 3 tables in one form.
I'm very new in access so pls help.
Alice

 

[aliceapraham]

Well, cool things happened here, when i ran as you told me to, a box opened up asking the company name (or customer) so when I'm puting the name it shows in the combo box like 12 records of the same name, & when I'm clicking on one of them, in the other fields, it bring wrong names. So that's not exactly what i want. But IT WAS COOL.
What I want is when I click the drop down list (the combobox), it shows me the comapny names, & I pick from them one name, & according to that, it brings me the sales man name in it's field.
Thanks
Alice

 

[TheAceMan1]

aliceapraham . . .

See my profile (click my name!)

See Ya! . . . . . .