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

[jobdone]

[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.

 

[pr2-eugin]

Why is this Form not bound to the table again?

 

[jobdone]

Why is this Form not bound to the table again?

It's bound to the Referral table, but not the property info table.

 

[pr2-eugin]

I am a bit can you explain what is your current setup and what you wish to achieve??

 

[jobdone]

I am a bit 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

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.

 

[pr2-eugin]

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?

 

[jobdone]

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.

 

[pr2-eugin]

Here is a Microsoft Article on Creating Form with SubForm. Read through it, you will be able to understand how easy it could be.

 

[jobdone]

Here is a Microsoft Article on Creating Form with SubForm. Read through it, you will be able to understand how easy it could be.

Oh man, it just clicked what you meant.

Yeah, I've used subforms before, and yeah, that is a much better option.

Thank you so much for guiding me through a brain melt

 

[pr2-eugin]

Glad to help ! Good luck