linking form and subform

D

Dennis Villareal

i had it working once but i have no clue what i did and can't duplicate it.

i have a form and subform and i want to lik them together. i guess i have
two questions here.

1-how do i link the forms together so when i select the data on one it
automaticly fills in the other subform data. two of the fields are the same
unique numbers.

2- can i get the data that is automaticly displayed to enter into the table
where the data is getting stored?

so i have a tbl that i am entering info in through the form
i have queries pulling the data from my system at work from the database
i have them as combo box to list all the possible data.
i have a order number if the order number is selected then i would like all
the other information to be displayed based on the queries and put into my
table and saved. so i can then build reports on the data in the table.

is there somewhere you can point me to the right direction?
 
D

Dennis Villareal

i have been reading about Cascading Combo box. is there a way to use this to
get what i need?
 

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

Top