This is slightly different question than the one I posted yesterday about using DoCmd. Thanks to Rory for his suggestion which worked perfectly!
This time, I have a new question… In the Microsoft Access 2000 Visual Basic for Applications Fundamentals book, there is a section on setting a DefaultValue method…For example, if I have a main form open, but then I want to enter payments for that particular record, then I would click on a button that opens Enter Payment form which automatically sets the Subscriber name to match the main form. In order to do this, in the OnOpen property, I would create a short code that looks like this:
If IsOpen(“Subscribers”) Then
SubscriberID.DefaultValue = Forms!Subscribers!SubscriberID
End If
I tried it out on the practice file that came with the book and it works perfectly. Exactly what I needed…HOWEVER…When I try this in MY OWN DATABASE, I don’t get full list of Visual Basic commands! I only get single command – “Value”. I tried entering this particular command in a new form in the practice file, same thing. Only the “Enter Payment” form would allow me to see full list of Visual Basic commands, including SetValue! I even compared the property sheets and couldn’t find anything different.
Why is this happening?
Thanks in advance.
