L
lucindaaps
Main table looks up to 2nd table, using this code:
SELECT [1a-Emb Format-tbl_Formats].[ID], [1a-Emb
Format-tbl_Formats].[Format] FROM [1a-Emb Format-tbl_Formats] ORDER BY
[Format];
In form view, when typing a value from the list, the value "auto completes"
fine until I close the database, re-open, add a new record and try to
populate the field again. Even if i type the copy exact value from the lookup
table list, an error results saying it doesn't match. I'm forced to click and
scroll on the drop arrow to populate.
When I remove the relationship from the lookup and rebuild the lookup, auto
complete works fine again, until the database is once again closed and
re-opened.
Could there be a property or tool option to change? Or perhaps Acesss needs
to be re-installed? I've never had problems with this feature in previous
Access revs so wondering if the issue is an Office 2007 known issue. Thank
you!
SELECT [1a-Emb Format-tbl_Formats].[ID], [1a-Emb
Format-tbl_Formats].[Format] FROM [1a-Emb Format-tbl_Formats] ORDER BY
[Format];
In form view, when typing a value from the list, the value "auto completes"
fine until I close the database, re-open, add a new record and try to
populate the field again. Even if i type the copy exact value from the lookup
table list, an error results saying it doesn't match. I'm forced to click and
scroll on the drop arrow to populate.
When I remove the relationship from the lookup and rebuild the lookup, auto
complete works fine again, until the database is once again closed and
re-opened.
Could there be a property or tool option to change? Or perhaps Acesss needs
to be re-installed? I've never had problems with this feature in previous
Access revs so wondering if the issue is an Office 2007 known issue. Thank
you!