Current Table and Field name

[azmirnordin]

Hi Guys

Let say I have a single form which datasource is bound to single table.
In vba code how can I possibly get the current table name and fields that my form used? Obviously I know the table name when I setup the datasource in the beginning but I want to know how to get it by using vba code..
Is it a way of doing it ?

Cheers

 

[gemma-the-husky]

you can work backwards via the forms SQL/recordsource etc.

Bit why do you want to do this? What are you trying to achieve? it's a very unusual thing to want to do.