Form Textbox value changes based on entry of another?

[djspod]

ProducingSiteID_PK	Supplying Site	SiteSAPNumber
31	Bolton	W1
32	Bristol	W18
33	Burnley	W3
34	Eastwood	W8
35	Enfield	W14
39	Newburn	W6
46	Stockton	W16
49	Tuscany	W15
50	Variety	W12
51	Wednesbury	W13
52	Gluten Free	W19

[djspod]

=DLookUp("[Supplying_Site]"," tblAllSites "," tblAllSites .SiteSAPNumber = " & Chr(34) & [text2] & Chr(34))

[andy49]

Is there an extra space after tableallsites. And before sitesapp etc?


Sent from my iPhone using Tapatalk

[andy49]

Oops no it's the delimiters for a string.
Should be

Sitesappnumber = '" & [text2] & "'")


Sent from my iPhone using Tapatalk

[djspod]

No, Does not seem so?

=DLookUp("[Supplying_Site]","tblAllSites","tblAllSites.SiteSAPNumber = " & Chr(34) & [text2] & Chr(34))

[djspod]

Oh I see, just popped out.
Really appreciate your help with this problem.

Just a quick question:

As a learning point for myself in vba when I get something like this again.

What's your methodology of breaking the issue down And working out the best code, Module, function to sort the problem out?

Or will this come in time?

Thanks

Darren



Sent from my SM-G935F using Tapatalk

[djspod]

I'll retry the ammendment Dlookup when I get back

Sent from my SM-G935F using Tapatalk

[djspod]

Hi Andy,

Reworked the Dlookup but is still not working for some reason?

I have added a copy of the DB if that helps?

=DLookUp("[SupplyingSite]"," tblAllSites ","tblAllSites.SiteSAPNumber ='" & [text2] & "'")



Thanks

Darren

[andy49]

TEST CC1.zip

I think the button is the best way round this.

I keep hitting errors via other routes

[djspod]

That works fine Andy, Many thanks!

To help myself I have your working out for my own understanding.
Great piece of work mate.

I guess each problem has a similar approach.

My understanding now needs to develop further so I can achieve the same methodical path on solving a similar DB problem.

Thanks for taking the time to help.

Darren


Sent from my SM-G935F using Tapatalk

[andy49]

Np don't forget to mark it as solved


Sent from my iPhone using Tapatalk