Re: vb6 to access 2003 vba

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

As Duane said, use .Value instead of .Text when referring to a control that
doesn't have focus.

If by "I'd like to make sure the text boxes are blank" you meant you want the
form ready for entering a new record, use this code"


Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Recurring Parameter Prompt
    ... Duane, I think I am doing just what you suggest. ... The only boxes that don't have defaults or multiple criteria are ... "Duane Hookom" wrote: ... > I would almost always use a control on a form. ...
    (microsoft.public.access.reports)
  • Re: One check box or the other
    ... If you choose to use only the bound check boxes, ... really do think it is the easiest to implement and control. ... When a vendor's certificate is due to expire we request an updated ... I don't see the value of using an option group to control a pair of check ...
    (microsoft.public.access.formscoding)
  • Re: How can I not save certain data?
    ... Card text box, ... control is one that has a field in the Record Source as its Control Source. ... Click the Event tab, and click next to On Current. ... Repeat for other unbound text boxes. ...
    (microsoft.public.access.forms)
  • Re: How can I not save certain data?
    ... It won't clear an unbound text box, ... control is one that has a field in the Record Source as its Control Source. ... lists people and their addresses, an apartment number field should be blank ... Repeat for other unbound text boxes. ...
    (microsoft.public.access.forms)
  • Re: How do I modify a dropdown box?
    ... execute the script script. ... You realize, of course, that with a single date control that will be all the ... My input page has 9 drop down boxes and a submit button. ... My validation is done on the Server using AJAX. ...
    (comp.infosystems.www.authoring.html)