Dlookup with variable field names (1 Viewer)

[thescottsman]

Hi All

I hope someone can help and see my error

I have a dlookup criteria that is to add a value into a choice of products depending on when the delivery of the product is going to be.

Me.Text114.Value = DLookup("[Me.Text92.Value]", "tbl_ActuatorMonth", "[ActuatorYear]='" & Me.Text110.Value & "' AND [ActuatorMonth]='" & Me.Text101.Value & "' AND [Me.Text114.Value]='" & Me.Text114.Value & "' ")

The error message that I am getting is as follows:
Run time error 3125
" is not a valid name. Make sure that t does not include invalid characters or punctuation and that it is not too long

 

[fvdb]

 AND [Me.Text114.Value]='" & Me.Text114.Value & "' "

You saying txt114 is txt114. Think this has to be deleted

 

[thescottsman]

Brilliant thank you - it always something simple