Combo box search error

[GraemeG]

Hello,

I have a combo box which looks up the unique number of each record on a form. I have 5 address fields populated with 10000+ records.

When you select the number in the combo box to find a record, it just changes that field number and does not change all the other fields related to that record.

Any help much appreciated?

 

[missinglinq]

What code is behind the combobox' AfterUpdate event? Did you use the Wizard's third option, "Find a record based on the value I selected in my combobox" in creating the combobox?

Linq ;0)>

 

[GraemeG]

Sorry no code or event is set up just a combo box attached to survey form.
The wizard does not seem to have a third option which says anything like that

 

[missinglinq]

Sorry no code or event is set up just a combo box attached to survey form.

Then how did you expect it to retrieve a record based on the selection?

You need to create a form based on your table or query, including all the fields you want displayed. Then simply:

1. Add a combo box to your form.
2. The Combobox Wizard will pop up
3. Select "Find a record based on the value I selected in my combobox."
4. From the table or query the form is based on, click on the field you're searching by (a field that is unique for each record) to move it to the right side.
5. Hit Next.
6. Size the column appropriately.
7. Hit Next.
8. Name the combobox.
9. Hit Finish.

Now you can drop the combobox down and scroll down to the item to search by, or you can start to enter the item, and the combobox will "autofill" as you type. Hit <Enter> and the record will be retrieved.

We've had high winds here, today, and the electric lines coming into the house were actually ripped off the side of the house, so the power will be cut any minute now, and I don't know when I'll be back on-line. If you have further problems, post back here, and I'm sure someone will step up and help you. This is pretty standard, native Access stuff.

 

[GraemeG]

Thanks.
I have managed to sort it.
I have inserted an AfterUpdate event procedure.
I will post on here for info for anyone who might need it.
Thanks anyhow

 

[lizymmm]

Can I ask what your afterupdate event procedure is?

I am trying to create a combo box for 'date' in the main form that brings up all records related to this date in the subform. I can create the box, however, I get an error message that says you cannot edit or delete records, without me trying to do either, it just pops up and I cannot look at the records in the subform let alone add any new ones to it....