Clearing all bound textboxes on an openform event

[webcrab]

Hi!
I have a form fthat contains 5 text boexes that are all bound to a table.
When i open the form it is full with the details from the table - i would Like the textboxes to be clear when i open the form since the form goal is to insert data to table and not to represent data (at least at opening)

Can you please give me specific details on how to do so?

thanx!

 

[maxmangion]

In the form's properties you can set the Data Entry Property to "Yes"

 

[webcrab]

Hi!
I have a form fthat contains 5 text boexes that are all bound to a table.
When i open the form it is full with the details from the table - i would Like the textboxes to be clear when i open the form since the form goal is to insert data to table and not to represent data (at least at opening)

i wouldn't want use dataentry=no peoperty


need your help!

 

[gemma-the-husky]

you cant do this, as such

with a bound form, the form opens at the first item in the record set - if you set the fields to blank, you are effectively clearing the data

so what you need to do is instead

a) open the form in data entry mode as already suggested (which you dont want) OR

b) on opening, goto the newrecord

in which case in formopen event (I think!) put something like

runcommand.accmdrecordsgotonew

it will either be this, or a docmd statement

I cant get at access at the moment, so i am not exactly sure of the correct statement

 

[maxmangion]

the code is

docmd.GoToRecord , , acNewRec