Entering data from a form into multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a textbox and a combobox. The textbox is not bound. The combobox must allow selection of values from "Table1" and when the user selects "Done", place the values from both the testbox and the combobox into a new record in "Table2"

Can anyone help with VB code or some other elegant method to complete this seemingly "simple" process

Thanks for the help

Mike
 
Just make both controls bound to the fields in Table2, in the normal way.

Mike said:
I have a form with a textbox and a combobox. The textbox is not bound.
Click to expand...
The combobox must allow selection of values from "Table1" and when the user
selects "Done", place the values from both the testbox and the combobox into
a new record in "Table2"
 
Andrew

If I do that, I still need some way to populate the combobox with values from Table1. Would this require VB code or is there another way

Thanks again

Mike----- Andrew Smith wrote: ----

Just make both controls bound to the fields in Table2, in the normal way

Mike said:
I have a form with a textbox and a combobox. The textbox is not bound
Click to expand...
The combobox must allow selection of values from "Table1" and when the use
selects "Done", place the values from both the testbox and the combobox int
a new record in "Table2
 
You just set the row source for the combo box to show the fields you need
from Table1. If you use the combo box wizard it will guide you through the
whole process. This is absolutely the standard way to use combo boxes, and
it does not need any code at all.

Mike said:
Andrew,

If I do that, I still need some way to populate the combobox with values
Click to expand...
from Table1. Would this require VB code or is there another way?
 
Back
Top