coding problem

[namliam]

Sarah,

XP (not sure about 2000) can convert back to 97

Tools=>Database Utilitys=> Convert database

I took the liberty of posting 1...

Regards

 

[sarahdaws]

thanks for trying to help both of you

I hope you can get it working properly

Sarah

 

[Mile-O]

I took the liberty of posting 1...

1 what? Apple? Banana?

 

[sarahdaws]

just to clarify, mailman, the error only comes up when you try to add and go to next record using the >* button at the bottom
sarah

 

[namliam]

Found IT

In future dont use the same names for a table, a query and a form!

You now have both a table and a form named Questionentryform

For 1 its not logical to name a table ....form
second Its not smart.. The error is popping up from your form, thus we are expecting thats where the error is. But NO... the error is in the table...

Questionno is PK, thus required but your form doesnt fill that field in the table (your combo box for questionno is unbound). Bind it and your problem is gone.

To prevent simular naming problems its smart to prefix all names
tbl before all tables
qry before all query's
etc

Regards

 

[Mile-O]

Re: Found IT

To prevent simular naming problems its smart to prefix all names
tbl before all tables
qry before all query's
etc

Don't use spaces or bizarre characters (i.e. ? / + - etc.)

And don't use Reserved Words - these can be found by typing Reserved Words into Access hlp.

 

[sarahdaws]

thank you soooooo much for your help and persistence wth this problem

Sarah

 

[namliam]

Did i not mention that?

I am so sorry Sir Mile!

Regards

 

[sarahdaws]

how do you change the properties to make it bound

 

[Mile-O]

Did i not mention that?

You mentioned prefixes.

I am so sorry Sir Mile!

Please don't apologise to the worker!

 

[namliam]

how do you change the properties to make it bound

Properties

Data tabsheet
Control source => Fill in the Questionnumber field from your table

Regards