Access and VB

[rtvillan]

I have written a code that a customer clicks an "open" button and chooses a database. Upon choosing, it opens up a form where a customer can input the text box with the date, cost, odometer, etc... and press a button to update or add.
How can I get the program to prompt the user to enter the date and odometer in a pop-up box and the rest of the fields manually? i.e. I want to make sure that the customer enter's the date and odometer before they go on to the rest of the field.

Thanks.

 

[jasek78]

try using input boxes...

i.e..

Private Sub Form_Load()

Dim str1, str2 As String


str1 = InputBox("Odometer Reading", App.Title)
str2 = InputBox("Date", App.Title)

txtOdo.Text = str1        'sub in the corresponding 
txtDate.Text = str2       'textboxes here...

End Sub

 

[MisterC]

Or you can disable the other controls until you have data in the ones you want - then enable them.

 

[rtvillan]

Thanks. It worked!