Gary,
I guess you would have a button, next to the dorp down combo, so that
you can force the bound tableto add new record.
But whether you add a record or select a record with the combo box you
will need to use one of the attached events of the form to which it
belongs to call some code that copies the string from the combo box, or
its bound colum into the "city" column of the row set bound to the main
form. At least that is the only way I can think of. As for which would
be the best event to use, "After Record Change" or "After Record Action"
or one of the others I am not sure. You would need to do a little
experimenting.
If I can help let me know. I would be happy to setup a small test form
and check it out.
Andrew
[EMAIL PROTECTED] wrote:
I have a form which is related to several tables. One table is a
single column list of data which I want to use for consistency. I
have a field where I would like to select from that table or add to
it in a form.
An equivalent situation would be a city field in an address database.
When adding a new customer it would be useful to select from a list
of cities but also be able to add an new city without going out of
the form to update the cities table.
I have tried adding a combo box and a table control to the form which
seems to let me add to (what would be) the "cities" table but I can't
seem to also get that new city into the current record at the same
time.
I'm sure there's an elementary solution but databases are new
territory for me.
Thanks for any suggestiuons
gary
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
