Is there a way...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which has a text box for entering in new project numbers. The
text box is linked to the table which obviously will hold the project
numbers. When the form pops up, the first project number shows, instead of
having the user use their mouse to click to the end of the table, is it
possible for the text box to automatically start at the end of the table so
new project numbers can be entered?
 
Antheny,

You can open the form in Data Entry mode in which case you will not see
existing records.
If you want to open it in a new record and still have all the records
available use the On Open Event of the form:

Private sub Form_Open()
DoCmd.GoToRecord, , acNewRec

End Sub

Regards/JK
 
You must log in or register to reply here.

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

synchronizing 2 combo boxes on a form Pt2 1
DELETE FROM a table WHERE... 1
Custom Parameter Query - Help, please? 1
New Data to Mulitple Tables 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
Simultaneously create records in multiple tables 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
What do you use your R-Pi for - which Projects are you planning!? 1

Back
Top