Form display (1 Viewer)

[rythem]

i have a form and it always displays the first record as it opens.
i dont want it to display any records and be just blank.

i have tried the code on Form_load
for i = 1 to col.count
col.item(i)=""
next

i dont know whats wrong with this code.

please help

 

[KenHigg]

At what point do you want to have it point to a record? When you click a button?

Ken

 

[KenHigg]

Are you wanting to open it and start entering a new record?

Ken

 

[rythem]

i just want that the first time i open the record, none of the users must see the existing records.

they must have to do a 'find" to get a record.

 

[trucktime]

Design

In Design View go to Properties, on the Data Tab set Data Entry to Yes

 

[Sergeant]

i just want that the first time i open the record, none of the users must see the existing records.

they must have to do a 'find" to get a record.

You could apply a filter in the form's OnLoad event. (one that will never return any records)

Private Sub Form_Load()
    Me.Filter = "PlayerID = 1000000"
    Me.FilterOn = True
End Sub

Set form's Allow Additions property to NO, and put your "Find" mechanism in the form's footer. Use this to change the Filter string to whatever they "Found".
Me.Filter = "Field = [whatevertheyfound]"