show blank records

[Guest]

I have various forms that have not been used for
inputting of data so naturally the table for the form
is blank. I use command buttons to navigate to these
forms.
use recnum = Me.CurrentRecord & DoCmd.GoToRecord , , acGoTo, recnum
Now because using this code allows me to load forms
and show the current employee details, when I go to
a form that I know the details have not been filled in
I keep getting the error 'cannot go to that record'.
I presume its because its table is blank.
Can anyone help please.

Thanks

Tim

 

[Guest]

its ok folks found the problem - inner join should be a left one.

Cheers.