2003 to 2010 Form migration problems

ian_ok

Registered User.
Local time
Today, 21:21
Joined
May 1, 2001
Messages
90
2003 to 2010 Form migration problems, not showing records

I've just moved my database from 2003 to 2010 and have encountered a few problems.

In my 2003 I had a menu and from this I could click on an open form button and it would open the form at whichever record (non specific, but a full record) and I could then use my combo box to select another record to view and then edit or I could click Add New to add a new record.

HOWEVER

When I click the menu button 'open my form', the form is opened in a NEW blank record and not with data visible in the record, also when I click on the combo box to select a different record, the list appears all OK, but the only information to be shown and visible is the record number, no data at all for that client.

I have tried to add a new combobox and still nothing happens.

To move from 2003 to 2010 I just opened the database in 2010 and all seemed OK apart from a active X error which appeared at the top and I accepted this (from memory)

I have also created a copy and changed it to the database as a accdb and the same as above still happens

Thanks for any help.

I have attached a revised version of the D/b in version for 2010 Access

Ian
 

Attachments

Last edited:
That is because you didn't add any LinkCriteria...

Code:
stLinkCriteria = "[ResID]=" & Me![ResID]

Adding that will make it open to the record selected.
 

Users who are viewing this thread

Back
Top Bottom