Unable to open blank data entry form

[nwm76]

Hi,

I'm trying to open a blank data-entry form, but for some reason, when I open my form, there is already old data populated in all the fields.

Data entry is set to "yes" in the property sheet.

Any ideas?

Cheers
Neil

 

[TheAceMan1]

How are ya nwm76 . . .

have a look at the forms [blue]Data Entry[/blue] property!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[nwm76]

Thanks Ace....but as stated in original message, my Data Entry property is set to "yes" as it should be, yet I still see data populated when the form is opened....

 

[bubba100]

How do you open your form?

 

[nwm76]

I've tried a couple of ways:

Creating a Switchboard button, using "Open Form in Add Mode".

and

DoCmd.OpenForm "DataEntry_Form", acNormal, , , acFormAdd


Same result both ways.

 

[SimonDavis]

How about set the form open event to

DoCmd.GoToRecord , , acNewRec

 

[TheAceMan1]

[blue]....but as stated in original message, my [purple]Data Entry property is set to "yes"[/purple] as it should be, [purple]yet I still see data[/purple] populated when the form is opened....[/blue]

I was just prompting verification of [blue]Data Entry![/blue]

Since you have [blue]Data Entry![/blue] already set in the form, you don't need any arguements in [blue]DoCmd.OpenForm[/blue] method! . . . Try:

[blue]   DoCmd.OpenForm "DataEntry_Form"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[SimonDavis]

Aceman - I think what he wants is a blank record when he opens the form. If I understood that correctly, going to a new record would have the desired effect.

 

[missinglinq]

Aceman - I think what he wants is a blank record when he opens the form. If I understood that correctly, going to a new record would have the desired effect"

And what does having Data Entry set to Yes do?

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

Thanks missinglinq!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[SimonDavis]

Well, apparently not what he wants it to do.

There are much better boards for pointless flaming, you know?

 

[TheAceMan1]

How are ya SimonDavis . . .

[blue]missinglinq[/blue] properly gave your thinking a little nudge! I see no [red]flaming![/red]

As one of the professinals here, I have been nudged enough myself . . . and have always been greatful for the wakeup call.

There's no need to be that sensitive if we are suppose to be the professionals!

If [blue]Data Entry[/blue] isn't working, its indicitive of corruption, meaning other things as well could go wrong!

So what happen to [blue]nwm76?[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[JoeAtWork]

Do the navigation controls show more than one record (e.g. "1 of 20")?

Is there any code in Form_Load, Form_Activate, or Form_Open that might override the Data Entry property?

And to confirm, these are are bound controls?

 

[nwm76]

Thanks guys for the comments.

The problem has been tracked down to a bad query that I was using as the basis of my form. Unsure as to why the problem manifested itself in the way it did, but my initial problem is now fixed.

Thanks and regards,
Neil