On Load Form question

[kai023]

I have a form (frmAims) that has a list box that the user can use to select records from a table (tblAims). It only contains 3 fields, the dept number (Dept), the dept name (Deptnam) & the aim (Aim).
I need a little bit of code I can drop in to the form load (or form open?)event that will bring the form up with no data in the fields.
I know I have done this before, but can not for the life of me remember / find it.

If anyone can help, it'd be much appreciated.

Many thanks

 

[TheAceMan1]

How are ya kai023 . . .

Perhaps the forms [blue]Data Entry[/blue] property is what your after?

See Ya! . . . . . .

 

[kai023]

Hi AceMan,

I'm afraid that doesn't work. It clears the form, but when the user then selects a record from the list box it gives an error of 'No Current Record'.

Thanks

 

[Eupher]

kai023,

Is this what you're looking for?

DoCmd.GoToRecord , , acNewRec

Ken S.

 

[kai023]

That's the fella!

Thank you very much.