data entry on form

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

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
 
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
Click to expand...

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]
 
Back
Top