Rererencing a Control in a Form

J

Jan T

I am using Access 2010. I want to reference the value of a Control in
one of my forms. In a standard module I tried this; lngEmpID = [Forms]!
[frmOvertime].Form![txtEmpID] and no problems.

However, I made a Navigationform an under a Navigation button (tab), I
added my frmOvertime as a subform to the Navigation form. The code I
used before now gives me an error. OK - so I figured I have to change
code to refer to a sub Form. I then tried this:

lngEmpID = [Forms]![frmMAIN]![frmOvertime].Form![txtEmpID] but this
also gives me an error?

Any help here will be very much appriciated! Thanks in advance!

Regards
Jan T.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing to a control on a subform 1
using 'bold' in a continuous form 1
set focus to control on subform 0
Requery main form after subform update and not lose place in main form. 3
DLookup in Continuous form 0
Dynamic Naming of Form Button 3
Clearing Fields in a Word Form 5
Direction for deleting records stored in two tables 5

Top