Combo Search Record Not working

willbo987

Registered User.
Local time
Today, 11:25
Joined
Oct 30, 2012
Messages
43
Hi,

Hope you can help me on this one.

I have a form called frmCandidates.

In the form is a combo box (Combo91) which should enable a user to select the candidates.

However, it does not work. I just cannot work it out.

I have attached database.

Thanks for your help in advance
 

Attachments

I dont know :(
 
I am creating a database for a new firm I am setting up.
Basically we do transport training.

But I have a candidates form (frmCandidates) with a search candidate function in the form of a combo box.

And for some reason I just cannot get it to work.
 
Because you form has no data, (form's query is wrong set up).
 
But if we go to tblCandidates, there is data there? I am confused now.

I appreciate all your help
 
Hi, a little more information.

When the combo box is used and a value selected, the form DOES change for a split second. Then reverts back to the original record???
 
CRACKED IT!!!
I had placed the field 'DrivingLicenceNo' from another table on the form.

If a candidate's driving licence details were not filled in, I was not able to select the candidates from the combo box.

When removing the field it works fine?
 

Users who are viewing this thread

Back
Top Bottom