Subform question

[Wayne311]

alright Wayne. I dropped all the source, and gave you an example.



attached is it. put a number in the top left box and see the charge appear.

Regardless of whether a parent child relay is present, you would have eventually run into the fact that your ID field in the table is TEXT, not a number.

vba syntax is different for these two datatypes, and confusing to boot.

Can you help me understand how this works?

As I understand you...this represtents dissimilar data types:

Me.Charge = DLookup("Charge", "Districts", "[District] = '" & Forms(Me.Parent.Name).Controls("CaseNumber Subform1").Form!District & "'")

How would it change for similar data types (both numbers)?

Thanks
Wayne

[RuralGuy]

Here is a good link to review: http://www.mvps.org/access/general/gen0018.htm

[ajetrumpet]

Me.Charge = DLookup("Charge", "Districts", "[District] = '" & Forms(Me.Parent.Name).Controls("CaseNumber Subform1").Form!District & "'")

How would it change for similar data types (both numbers)?

'D' functions only change syntax, as it relates to data types, in the criteria argument. and moreover, working with criteria statements in access, via code or interface is always unnecessarily complex. Don't ask me why, I don't know. The data type that inevitably ends up being thrown into the right side of an operator sign in a criteria statement ALWAYS dictates the format of the quotation and symbol syntax.

the above example, when used with a number, would be:

Me.Charge = DLookup("Charge", "Districts",

 "[District] = " & Forms(Me.Parent.Name).Controls("CaseNumber Subform1").Form!District)

that's called concatenating a value out

you can also concat it in

the difference between doing it IN and OUT is almost strictly related to numbers and dates VS. text.

this is IN:

"something = '" & textvalueReference & "'"

if you print statements like this out in the immediate window, what you see is this:
something = 'textvalueReference'

this is OUT:

"something = " & numbervalueReference

if you print statements like this out in the immediate window, what you see is this:
something = numbervalueReference

and this is also OUT:

"something = #" & datevalueReference & "#"

if you print statements like this out in the immediate window, what you see is this:
something = #datevalueReference#

that's the best I can do.

please please PLEASE read what Allan posted. MVPS has about the simplest explanations that you're going to find on the web. At least those that come from a tutorial-type website. (I don't read their stuff....I only use their freebie services to block annoying advertisements on forums like this. )

[Wayne311]

Thanks for both posts. That helps a lot.

Wayne

[ajetrumpet]

can we marked this as solved, Wayne?

Actually, I'm going to...and if you have more questions pls start another thread.