#NAME? on bound controls with gotorecord acnewrec

Thread View: comp.databases.ms-access

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Bj�rn Fabritius Fri, 15 Dec 2000 15:07

#547

Author: Bj�rn Fabritius
Date: Fri, 15 Dec 2000 15:07

18 lines
2173 bytes

Hello there,
I got a problem with a form:
when I open the form I use the DoCmd.GotoRecord ,,acnewrec - method in my
Load-Event to show an empty dataset.
No problem, would you suppose, but somehow all values in bound controls
change to #NAME?. And: I can't edit them.
All recent records of the sourcetable are shown without problem. i.e. I can
switch through the records using the navi-buttons.

Even stranger is, that this effect only occurs on one single computer. All
computers refer to the same database (linked tables) and all use Access
2000.

What the @%*# can cause such a strange behaviour ???

Thanks for your help
yours
    Fabric

Re: #NAME? on bound controls with gotorecord acnewrec

#548

Author: Karl Donaubauer
Date: Fri, 15 Dec 2000 15:48

27 lines
2479 bytes

Bj�rn Fabritius wrote:
> I got a problem with a form:
> when I open the form I use the DoCmd.GotoRecord ,,acnewrec - method in my
> Load-Event to show an empty dataset.
> No problem, would you suppose, but somehow all values in bound controls
> change to #NAME?. And: I can't edit them.
> All recent records of the sourcetable are shown without problem. i.e. I can
> switch through the records using the navi-buttons.
>
> Even stranger is, that this effect only occurs on one single computer. All
> computers refer to the same database (linked tables) and all use Access
> 2000.
>
> What the @%*# can cause such a strange behaviour ???

Do you use Default Values in the controls/fields?
Maybe by using any functions in expressions?
Then it could be bug #1 = references.
http://www.mvps.org/access/bugs/bugs0001.htm

Check the references anyhow.

--
HTH
Karl
*********
Access-FAQ (German): http://www.donkarl.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads