Load Form

[mfuada]

Hey guys, here's my problem, i have a form to input data into tabe, and i want the form to display a blank textbox which we put the input data in there... i've tried

Private Sub Form_Load()
inputname.text = " "
End Sub

and

Private Sub Form_Load()
inputname.text = null
End Sub

the inputname textbox is related to field name in my table, could you guys tell me what's my mistake and tell me the right script?
thx...

 

[DCrake]

If the text box is bound to a field in an underlying table or query then whatever is in the field in the table/query will appear in the textbox. The only times it will be blank/null/empty is when it is a new record or if nothing has been previously entered into this field.

David

 

[mfuada]

Okey, So is there anyway when i open the form, the textbox automatically sets into new(blank) record?
or i have to just make the textbox unbound with the fields in the table,which means i can't make the form, from the wizard menu.is that correct?
Thx....

 

[DCrake]

If this form is to be used for adding records only then go to the forms properties and set the mode to adding.

 

[mfuada]

i'm very2 sorry.. but i can't find the "mode" on the form properties... could you be more specific where i can set the mode to adding??
thanks!

 

[DCrake]

You need to be looking at the property "Data Entry" Which is beneath "Allow Additions"

 

[mfuada]

Okey thanks... that help a lot... thx