Trouble opening to blank form

G

Gina Whipp

Try...

Another thought... Please rem out the line or remove it and open the form
with the subform. Does anything on either one of those forms those #NAME?
in the field? Are the fields bound or unbound? Also, check the record
source of your combo box on your Main form. OR are you already at the last

I also noticed you have DoCmd.GoToRecord , , acNewRecord and I have
DoCmd.GoToRecord , , acNewRec However, seems to me you should be getting
another error if it didn't like yours.

And yet another thought... those two tables you are using for form/subform
are they a one-to-many relationship?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
T

tdp

Gina!! I changed acNewRecord to acNewRec, and that does the trick! Thank you
so much!!

See, this is what happens (to me) when I fool around with VBA and know
nothing about it <sigh>....

Thanks again, and thanks to everyone else who tried to help.

tdp
 

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

Dynamic Naming of Form Button 3
Trying to remove error from conflicting code 0
Opening a blank form 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Protect form & open form to blank upon entry 1
Open to Blank Form 5
Controlling a Sub Form 4

Top