Combo Search Record Not working

[willbo987]

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

 

[vbaInet]

What is the problem this time?

 

[willbo987]

I dont know

 

[vbaInet]

I'm trying to understand what you're trying to do.

 

[willbo987]

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.

 

[JHB]

Because you form has no data, (form's query is wrong set up).

 

[willbo987]

But if we go to tblCandidates, there is data there? I am confused now.

I appreciate all your help

 

[willbo987]

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???

 

[willbo987]

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?