Requery Question

[JenNorthwood]

Hi There,

I am having trouble figuring out how to requery my form to get rid of an error I am getting.

Run-Time error 3070: The Microsoft Jet Datbase engine does not recognize TrainingID as a valid field name or experession.

I press ok and it still works.

This error occurs when I pick an option from my combo4 box.

Set rs = Me.RecordsetClone
rs.FindFirst "[TraningID] = " & Str(Nz(Me![Combo4], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Thanks for your help.


I have the parent form frmtraining, and a subform sfrmEmployeeTraining.

It usually happens after I add a new record.

Do I new a requery command somewhere

Thanks,
Jen

 

[JenNorthwood]

I have attached a sample of the problem.

Any help would be great.

Jen

 

[soundsfishy]

it is probably because u have not spelt the control source name correctly. . U are missing an "I" in TrainingID

rs.FindFirst "[TraningID] = " & Str(Nz(Me![Combo4], 0))

 

[Pat Hartman]

If TrainingID is numeric, why are you converting the contents of the combo to a string?