Can you use Dlookup values as search criteria on a form?

jobdone

Registered User.
Local time
Today, 23:30
Joined
May 9, 2013
Messages
17
[SOLVED] Can you use Dlookup values as search criteria on a form?

Hey,

So I'm working on something for housing. Each house has a "Property Reference". This property reference links to all other information on the property.

There's two tables, Referral (For a tenant, with the Property Reference as a foreign key) and PropertyInfo (Holding all the property information)

Basically I want to save users as much input time as possible, so I'd prefer if they could just enter the property reference for a person, and that populates the rest of the table.

I'm currently using DLookup on the main form where it displays the information related to the property reference, obviously it's not actually being saved into any fields.

Will this method be okay if I would want to search the records by the address on the main form?

Sorry if that's confusing, if you need clarification just ask.

Thanks for any help.
 
Last edited:
Why is this Form not bound to the table again?
 
I am a bit :confused: can you explain what is your current setup and what you wish to achieve??
 
I am a bit :confused: can you explain what is your current setup and what you wish to achieve??

Yeah, sorry, I forget not everyone can see what I'm working on atm :p

Basically, two tables:

Referral

Referral ID
Tenant Name
Date of Referral
Property Reference (The foreign key)

Property Info

Property Reference (Links to Referral table)
Address1 (E.g. 1 Smith Road)
County
Postcode

After this I have a form which is bound to the Referral table. It displays all the referral table information. I'm using the Dlookup function to display the property info, the address/county/postcode.

Because this information is not being held directly in the Referral table, I was wondering if it would be possible to search the records (From the referral table) using the address information that is being displayed via DLookup.

Hope that helps.
 
Why not create a Form SubForm setup? This way you do not need to over complicate usage of DLookUp statements.

How are you performing search?
 
Why not create a Form SubForm setup?

Sorry, could you elaborate on that?

Tbh I'd prefer to not faff about Dlookup and just have all the information entered into the referral table, but I want people to have to update as little as possible.
 

Users who are viewing this thread

Back
Top Bottom