How to find out information on form's current record (1 Viewer)

[darkmastergyz]

My form's control data is currently linked to a query. I'm trying to use vba to get information about the fields in the current record.

I think it's supposed to be:

Forms!Form1. (something here?)

But I just can't seem to figure it. What code am I supposed to use? Thanks!

 

[pbaldy]

Here's a handy reference:

http://www.mvps.org/access/forms/frm0031.htm

 

[darkmastergyz]

Thanks for the link, but I still can't seem to get it to work. Here's what I'm doing:

Me.RecordSource![ID]

and it's not working...

 

[pbaldy]

I didn't notice that anywhere on the link. Try this:

Me.ID

 

[darkmastergyz]

Oh ok that works on one field. But, in another field, in the query, I have a dot in the name of the field, eg. it's data.Pri What should I do in that case? Thanks!

 

[pbaldy]

If you have a dot in the field name (inadvisable), you'd have to bracket the name.

[data.Pri]