DLookup Problems in Access Form

[mccloy1285]

Hi,

I have a form which has shift information on it. Name, Date, Machine etc.

I have created a small table for machine targets which looks like this:

Machine, Throughput, OE, JE, OEE
Control 1 77% 70% 96% 51.2%
Control 4 60% 70% 91% 48.8%

I have then created a query of this table, called "qSelMachineTargets" so that this data can be found easily.

In a text box in my form I have the equation:

=DLookUp("Throughput","qSelMachineTargets","Machine=" & [txtMachine])

so that depending what machine is shown in the form, either Control 1 or Control 4, it can lookup and find the respective throughput target. My problem is that I only get #Error when I view the form.

Can anyone help please?

 

[xenou]

Try using single quotes around the last argument:
=DLookUp("Throughput","qSelMachineTargets","Machine='" & [txtMachine] & "'")

Text literals must have quotes. You have to put this in when you create the string expresssion.

 

[mccloy1285]

Thank you! that worked perfectly! Its obvious when I look at it, I wish I had noticed that hours ago!