New records on form when there is a combo box

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

Guest

Hi was wondering if anyone could help

I have 4 forms which all have combo boxes on them, when i try to create a
new record on the form i get an error message when it comes to typing in the
combo box. It says "the text you entered isnt an item in the list, select an
item from the list or enter text that matches one of the listed items"

I dont want to select an item from the list as i want to create a new
record, not use one of the other records. Anyone know an easy way of sorting
this problem? im sure its probably a simple problem.

cheers

ricardo
 
The simple way would be to exchange the combobox to a textbox.

You can work with the property "Not on the list" and search the newsgroup on
how to use it.
 
Yeah but i want to keep the combo boxes, they are used so that the user can
easily search for records by typing them in. then once they click on a record
all the other boxes change on form to display information, if i changed it to
text box then the user wouldnt have a quick way of finding what they are
looking for.
 
One way is to put the combobox in the header for searching, unbound, and use
a textbox, bound, in the main form for when you wish to enter new records.
 
Cheers Karl that seems to work. i already have all the combo boxes unbound in
the headers of each form, so i just basically had to make a text box visible
 
Back
Top