Search Combo on Form

[RussG]

I added a Search lookup Combo Box at the top of a form.
This worked fine until I changed the Forms record source to a query. Don't quiet understand why this doesn't work now. Is there another way to achieve the same function.
Thanks
RussG

 

[Dudley]

I'm not sure, but I think the Search combo box needs to be unbound.

 

[RussG]

Hi Dudley, the search box is unbound. I have had a look at all the properties, can't see what it could be at all.
Thanks
RussG

 

[Dudley]

can you put up a copy so we can take a look?

 

[RussG]

I have based the form on a query in order to sort the waiting list in date order.

You will notice that I have a button to lock the record, this is because 2 -3 people will access the form at once and this stops more than one user working on the same record.
I Had the same issue with search on a query based form last week in another DB so I don't think the locked record is the problem.
Thanks for your help.
RussG

 

[Dudley]

The problem is your record-locking code that sets Me.AllowEdits to No. This prevents your search combo from changing - no edits. I added a couple of lines of code to set AllowEdits to Yes on GotFocus and No on LostFocus and to set the focus on RecordID after updating the bookmark. You'll need to work with these to maybe adjust the AllowEdits Yes/No depending on the value of your RecLock checkbox.

 

[RussG]

I understand, many thanks for your help it's much appreciated.
RussG