ACCESS: Pass data from user input form to query and back to form

[klepac99]

I have a form that I have created for user to enter data for a possible record to be created. I only want to create this record if the data entered is correct and has a "master record". Example: I ask user for customer number. I take the user input and query the customer_table to return to same form the customer name and address. At this point, I also want to allow user to enter transaction data for this customer to create a record for another table customer_transaction_table. How do I pass information back and forth and add data from the table? If I can only use 1 data source how can I retreive from 1 table and then append a another table with combined data? How do I join forms to queries and tables?
Thanks in advance for any help you can provide.

[ranman256]

You can have an 'input' table,
on the form ,pick customer Id,
lYou have a sub form linked to custID,this shows all customer info.
change the ID field, the customer info changes too.

Enter all your data, check validity.
user clicks a 'save' button, this will execute append queries to pass data to the target tables.