Table/Form Question

[Guest]

Got a feeling I'm doing this all wrong, but here goes

I have a form with a field "Postcode" that is generated by a Dlookup expression. This works fine, but when I need to run a query the Postcode field is blank in my table

How do I get the "Postcode" field to populate in my table

My Dlookup is : =DLookUp("[Postcode] ","[Suburb]","[Suburb]![Sub] =" & "[Suburb]"

Thank

Alfie

 

[Lynn Trapp]

You Postcode field on your form needs to be bound to the Postcode field on
your table.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Got a feeling I'm doing this all wrong, but here goes.

I have a form with a field "Postcode" that is generated by a Dlookup

expression. This works fine, but when I need to run a query the Postcode
field is blank in my table.

How do I get the "Postcode" field to populate in my table?

My Dlookup is : =DLookUp("[Postcode] ","[Suburb]","[Suburb]![Sub] =" & "[Suburb]")

Thanks

Alfie

 

[Guest]

Lynne

Thanks for replying so quickly

I can't bind the control on the form to the table as the field has the dlookup expr in it

Alfie

 

[Douglas J. Steele]

In addition to Lynn's comment, your DLookup statement is incorrect. It's
trying to lookup the Postcode for the literal value [Suburb]. I assume you
actually want it to look at the value contained in a field on your form
named Suburb.

=DLookUp("[Postcode] ","[Suburb]","[Suburb]![Sub] ='" & Me.[Suburb] & "'")

Exagerated for clarity, that's

=DLookUp("[Postcode] ","[Suburb]","[Suburb]![Sub] =' " & Me.[Suburb] & " '
")

If there's a chance that the suburb might contain an apostrophe, you'd be
better off using:

=DLookUp("[Postcode] ","[Suburb]","[Suburb]![Sub] =" & Chr$(34) &
Me.[Suburb] & Chr$(34))


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Got a feeling I'm doing this all wrong, but here goes.

I have a form with a field "Postcode" that is generated by a Dlookup

expression. This works fine, but when I need to run a query the Postcode
field is blank in my table.

How do I get the "Postcode" field to populate in my table?

My Dlookup is : =DLookUp("[Postcode] ","[Suburb]","[Suburb]![Sub] =" & "[Suburb]")

Thanks

Alfie