combo box question

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

Guest

Hello. Im another half wit novice user who likes to ask dumb questions! As part of my new job I've been asked to make some modifications to a simple database we use. I have a form that adds data to a particular table/query and uses a combo box to find the correct record to add the information to. No problems there. Sometimes though, the data needs to be added to a new record that is not found in the list supplied by the combo box. My question is how do I add a new record using this combo box feature, or should i perhaps think of using a checkbox or something along those lines. Ive tried modifying the Limit to List function to No, and this partly works but instead of entering the data to the new name that i assign, it uses a name in the list and adds the data to this. What is this numscull doing wrong???
Sincerely awaiting a reply
Luke
 
when the combo box's code is set to find a record in the form's underlying
table, that's all it does - find an existing record. if you want to also add
new records using this same form, you can make sure the form's
AllowAdditions property is set to Yes. then add a command button, using the
Controls Wizard (button on the Toolbox toolbar in form design view); in the
dialog box, select category Record Operations, and action Add New Record.
the wizard will write the code for you.

to make sure new records are added to the combo box's droplist, add a
Requery action to the combo box's OnEnter event.

hth


Luke said:
Hello. Im another half wit novice user who likes to ask dumb questions!
Click to expand...
As part of my new job I've been asked to make some modifications to a simple
database we use. I have a form that adds data to a particular table/query
and uses a combo box to find the correct record to add the information to.
No problems there. Sometimes though, the data needs to be added to a new
record that is not found in the list supplied by the combo box. My question
is how do I add a new record using this combo box feature, or should i
perhaps think of using a checkbox or something along those lines. Ive tried
modifying the Limit to List function to No, and this partly works but
instead of entering the data to the new name that i assign, it uses a name
in the list and adds the data to this. What is this numscull doing wrong???
 
Back
Top