Access to a Forms Data-Fields by VBA without having a Data-Control on the Form? (1 Viewer)

S

schittli

New member

Local time

Today, 19:43

Joined

Mar 18, 2009

Messages

4

• Mar 18, 2009

• #1

Good morning

In the OnFormat Event I would like to access all the Recordset-Fields of the form - without having to place a control to the form for each field.

Is there a solution for that?

Thanks a lot in advance,
kind regards,
Thomas

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 10:43

Joined

Aug 30, 2003

Messages

36,125

• Mar 18, 2009

• #2

Welcome to the site. You don't need a control on the form to access a field's value, as long as it's part of the form's source. Normal "Me" syntax should work.

 

S

schittli

New member

Local time

Today, 19:43

Joined

Mar 18, 2009

Messages

4

• Mar 18, 2009

• #3

Thank you very much, Paul, for your fast anwer! you're right, in forms the normal "Me" syntax works perfect - I came from reports where it looks like a field's value is not accessible by the "Me" syntax. strange.

Kind regards,
Thomas