Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

setting form onopen to record and such

Status
Not open for further replies.

Donkeygirl

Technical User
Nov 30, 2000
52
US
I posted this in a reply in Access, and then put it in forms, because it does belong here. But really this comes down to vba, lol. I am sorry for posting this so many times. I was banging my head into the wall trying to solve this last night.

I was almost set with this onopen statement of the form, but now it is all screwed up. The idea is that I need to det two option groups on the form to null --> ME![opgrp] = Null and to fields to where I want them, so that the form will show that record on start up.
Me! [LT]= "06"
Me! [LT] = "001"
This was working for a while when there was a DoCmd.GoToRecord in the first line. Then the goto stopped working and the form could not match the code to the statment. Ahhhh. I am still trying to figure out how I can set this form on open to have those settings of null option groups and the record showing at the first one. If you can help here, that would be great.
Thanks :))
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top