Using a form to add a new record

[julesinbath]

Hi,

I am trying to make my timesheet form add a new record. But when I click on the "add new record" button I get an error message that states: "You can't go to the specified record".

"Allow Additions" is set to "Yes".

Has anybody else had this problem?
Jules

 

[KenReay]

Hi

Is the query on which your form is based an updatable query?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[julesinbath]

Hi Ken

Forgive my ignorance, but how do I check whether the underlying query is updatable or not?

Jules

 

[KenReay]

Hi

TRy just running the query, then try to update any row, see if it lets you, if it is not updateable message will display in status bar

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[julesinbath]

The query is not updateable. But I don't know why not.

I managed to get around the problem, by reverting to an earlier version of my database. Obviously there must be some subtle difference, but I just can't see it.

Thanks very much for your time, Ken.

Jules