Blank fields on opening or loading of form

[nrmarthi]

Hello guys

How can get blank fields on opening or loading my form?. I don't want to prevent data entry option.

Please help me

Thanks

 

[RuralGuy]

Does setting DataEntry to Yes give you what you want?

 

[nrmarthi]

it preventing me from entering data, i wanna get blank or new record on opening of form.

Thank you for reply

 

[RuralGuy]

Do you have Allow Additions and Allow Edits set to Yes?

 

[nrmarthi]

Yaaa, they are, shall i turn to "No"?

 

[RuralGuy]

They are set correctly. With DataEntry set to yes the form should *only* show you *new* records. Are you sure your query is updateable?

 

[nrmarthi]

I am getting blank record with that, but i created a Text Box to tell me what is the maximum record # i already entered, so that user need scroll up & downto confirm. (I used simple 'Max' command in that Text Box).

My question is, when i put 'DataEntry' to 'Yes', am neither able to see maximum record that is entered nor scroll through data. i created command buttons for 'Goto Previous record' and 'Goto Next record'

Appreciate for replies

 

[RuralGuy]

it preventing me from entering data, i wanna get blank or new record on opening of form.

Has the original requirement changed? Can you now enter data?

 

[nrmarthi]

yaaaa, i can enter data with 'DataEntry' 'Yes', but i can't scroll through records to understand maximum number entered. So i created a Text Box. Am not getting any resposnse. But if i use "DataEntry' to 'No', then i can see maximum # i had entered in that field.

 

[RuralGuy]

You know you can add a new record and enter data in the new record without being in DataEntry mode?

 

[nrmarthi]

ohhhh really? how can i do that. please tell me.

 

[RuralGuy]

Is your form in SingleForm mode or ContinuousForm mode? Have you tried DoCmd.RunCommand acCmdRecordsGoToNew?

 

[nrmarthi]

its Single Form mode

i haven't used "DoCmd.RunCommand acCmdRecordsGoToNew"

 

[RuralGuy]

Put that DoCmd line in the Form's OnLoad event and see if that will work for you. Set DataEntry = No.

 

[nrmarthi]

ohhhhh great

its working. THANKS LOTTTT Mr. RuralGuy

keep posting my doubts. Thanks again

 

[nrmarthi]

ohhhhh great

its working. THANKS LOTTTT Mr. RuralGuy

keep posting my doubts. Thanks again

 

[RuralGuy]

Glad I could help. Your English is pretty good! If you don't mind me asking, what is your native language?

 

[nrmarthi]

How can i deactivate mouse second button click on form?

 

[nrmarthi]

How can i deactivate mouse second button click on form?

 

[RuralGuy]

Please start a new thread with this question.