|
|
Hi.
I want to make an array in VB (inside Access) that will:
1) select the data from the fields in a record, in a form
2) put the data in an array
3) find out if there is any fields with data not inputed
4) give a message to the user e.g. you have not entered data in: ****
5) where **** is the field where data is missing.
I have:
Private Sub Command13_Click()
Dim count As Integer
cname.SetFocus
If cname.Text = "" Then
MsgBox ("You have missed 'Contact Name' from the data")
count = count + 1
End If
If count = 1 Then
cname.SetFocus
Else: DoCmd.GoToRecord , , acNext
End If
End Sub
this only looks in on field, and i dont really want to copy it all out for each field on each record.
Can anyone help?
Will
|
|
|
|
|
|
|
|
blockers
