VB / Access Problem

[ByteWipe]

Firstly, before I launch into this problem, I'd like to apologise for the lack of knowledge in Access. This is likely to be a simple problem, but I find Access harder to develop in, being mainly a Pure VB programmer.

Basically, I want to refer to a control, lets say for arguments sake its a label, on one form from the code generated on another form. I think the code is OK, but when I run it by clicking on a command button, Access throws a wobbler and tells me that:
'Microsoft Access cannot find the form 'frmTimeDetails' referred to in a macro expression or Visual Basic code.'

Basically, I'm using the following expression:
Forms("frmTimeDetails")("lblDate").Caption = strDate
where strDate is a string variable.

One way I can think of getting round this problem is to open the form and then make it non visible. However, I'm not too sure how to do this. In VB, all I need to write is frmTimeDetails.Show to open the form, but it's not working.

I'm sorry if this is a really simple problem, but I really need it answered, the help file really is a load of rubbish, can't seem to find what I want!

Hope someone can help

[ByteWipe]

ah, got it working, current code stands as:

DoCmd.Openform "frmTimeDetails"
'make form invisible whilst processing goes on in background
Forms![frmTimeDetails].Visible = False
Forms("frmTimeDetails")("lblDate").Caption = strDate
Forms![frmTimeDetails].Visible = True

thanks,

[Daniel ~]

Glad "WE" could help you! LOL Welcome to our forums hope you'll stay around and help others! Be well!

[ByteWipe]

Yep, you seem like a cool bunch

Hehe, sorry about that, I always seem to ask someone about a problem and then figure out how to do it about 5 minutes later. Always the way.

Ill be glad to help if anyone has any problems. Hoping to go to university and specialise in software engineering, so perhaps this forum is the place for me!

[Daniel ~]

If you don't find what you need let me know. I like to think of us as a Saran wrap forum, clinging to our users needs where ever possible! ":O}