data entry on form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DD - 09 May 2007 00:38 GMT

i have a form that is linked to a table. all i do is enter data from the
form. i converted the database from 2000 to 2003 because i want to use with
runtime. for some reason the form doesnt open up in data entry mode. i can
scroll through records etc but the * is not available to use to create a new
record. it worked no problem before now its not. everything is checked for
the properties for data entry. when i use the database with runtime, the
total form is blank. thats another story. does anyone have any ideas what
is happening.

thanks

Reply to this Message

John W. Vinson - 09 May 2007 06:13 GMT

>i have a form that is linked to a table. all i do is enter data from the
>form. i converted the database from 2000 to 2003 because i want to use with
[quoted text clipped - 6 lines]
>
>thanks

2003 is sometimes more stringent about what queries can be updated and which
cannot. This symptom suggests that you have such a query - updateable in 2000,
not in 2003.

Please open the Form in design view, and view its Properties. What's in the
Recordsource property? A Table, or (more likely) a Query? If a query, please
post the SQL view.

John W. Vinson [MVP]

Reply to this Message