How do I reference a table field of the current record

[mdavid]

Hi,


Maybe a dumb question, but I can't find the answer (I did try) so I'm back.

I have some fields on form1, I want to pass fields in the current record that are not on form1 to populate fields on form2.

I know of a couple of ways

1. put the fields I want to pass to form2 as hidden fields on form1.
2. use Form2.textbox = Dlookup("Fieldname","TableName","") - not sure if this takes from the current record

Thing is if I want to pass a form field I'd just write Form2.controlName = Me.ControlName, so I was thinking that if "Me." was the shorthand way to refer to a form field, there should be a similar way to refer to a table field in the current record like "Tbl.FieldName".

Is there such a thing?

Thanks
David

[Bob Fitz]

I'm sorry to say that I have no idea what you are trying to do. I think it might be better for you to tell us what your business is dealing with and what you are trying to do. Try not to use any database terms like fields and tables etc

[mdavid]

Hi Bob, Sorry this wasn't clear - it's a general question about Access not related to what I'm trying to do.

In the same way you refer to a form field as Me.[ControlName], how would you refer to a table field in the current record?

Thanks
David

[Bob Fitz]

Hi Bob, Sorry this wasn't clear - it's a general question about Access not related to what I'm trying to do.

In the same way you refer to a form field as Me.[ControlName], how would you refer to a table field in the current record?

Thanks
David

Providing the field is in the forms Record Source table/query then you just need to type the field name. The Me. is not required. Square brackets will be needed if [field name] has spaces.

[mdavid]

Thanks Bob, So simple - just not obvious to me.

[Bob Fitz]

Thanks Bob, So simple - just not obvious to me.

It wasn't obvious to me either, but at least I am simple