Link to home
Start Free TrialLog in
Avatar of hak66
hak66

asked on

EOF Formate

"Data1.Recordset.MoveNext or MovePrevious" When  I type this code and hit the command button, I get error message. I know that  I need to Type EOF or BOF for each data control but I don't know how, can you please email me the code for EOF and BOF to dispaly my database within VB without getting an error message. Thanks
my email is   Hadorth11@aol.com
Thanks
Avatar of khaledc
khaledc

You may have to open the record first, can tell me what are you exactly trying to achieve, may be I can help.
I goes something like this ...

IF EOF(#filenumber) then exit do

ASKER CERTIFIED SOLUTION
Avatar of cerik
cerik

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Try placing this code in your command button's click event:
If Data1.Recordset.EOF = True or Data1.Recordset.BOF = True Then
    Exit Sub
End If

Data1.Recordset.MoveNext
or
Data1.Recordset.MovePrevious

Avatar of hak66

ASKER

Thanks, I will be contacting you after I try it. I appreciate your time and consideration!!!!