Lookup fild on form in ms access 2003 not work in ms access 2007

[Sok Sokkheng]

Hi
My database use ms access 2003, and now I use ms access 2007. The problem is on form that have lookup field it not show, untill I click on the text box that for store that value it just show.
How can I fix this problem?

regards
Sokkheng

[rpeare]

Are you using FORM view?

Or are you using LAYOUT view?

LAYOUT view for forms has this behavior in 2007+, as does LAYOUT or REPORT view on reports.

Also, have you considered making a copy of your database and upgrading it to 2007? or are you required to leave it in 2003 because other people in your office are still on 2003 as well.

[Sok Sokkheng]

Are you using FORM view?

Or are you using LAYOUT view?

LAYOUT view for forms has this behavior in 2007+, as does LAYOUT or REPORT view on reports.

Also, have you considered making a copy of your database and upgrading it to 2007? or are you required to leave it in 2003 because other people in your office are still on 2003 as well.

Thanks for your reply,
please give me an advices how should I do, I want to use ms 2007 all my pc. So my database should work properly in ms access 2007.
thanks in advance.
Sokkheng

[rpeare]

Updating the database to 2007 will likely not fix the issue in itself. You haven't really answered either of my questions about *how* you are viewing your report or form.

If you use FORM VIEW (for forms) or PRINT PREVIEW (for reports) you should see the values without any issue.

If you want to convert the database to 2007:

1. Make a copy of your database before you do anything
2. Use the tools in MS access to convert the database to a more recent version (in your case 2007)
3. Test the converted database to make sure it still functions the way it should
4. Replace the older version database with your new database.