cboselection box-can I use it to enter data?

  • Thread starter Thread starter Lovespar
  • Start date Start date
L

Lovespar

I have a form to make modificatins on data based on a number and that part
works well, however we need to be able to also enter data using this form
whick means typing in the number on a new record instead of just choosing it
from the drop down. this is an unbound record, with the Row Source being a
query.
Limit to list is No, Allow value List edits is Yes, locked is No.
Any help will be appreciated.
 
Not 100% sure what exactly you want to do, but yes, you can enter data with a
combo. Use the combo box wizard to set up what you want. With it, you can
find records or look up records. You need to tell the wizard what query you
want and what field.
 
that is the problem, I can use the combo to look up records and align the
form with the record I have chosen, but it will not accept data that I type
in.
I have used the code from Tom Wickerath to find existing records but I also
need to be able to create new records and add to this field.
 
that is the problem, I can use the combo to look up records and align the
form with the record I have chosen, but it will not accept data that I type
in.
I have used the code from Tom Wickerath to find existing records but I also
need to be able to create new records and add to this field.
Click to expand...

It's really best to use two different combo boxes for these two different
tasks. A Combo used for navigation will overwrite and destroy the data in its
Control Source if it's bound (unless you use some moderately tricky code).

I'll often put navigation controls in the form Header and make them a
different color, so the distinction between the two tasks is clear.
 
Back
Top