Microsoft 2007 Access

[AUDSD2]

Please help. I am trying to convert my access from 2000 to 2007 and
running into two problems so far. first is that i am told that the
gotocontrol on a macro to go from a form to a subform is no longer
available. what do i use? how do i get around this?

second the field in my main table is called letter and is what is
unique to all of my tables. when i try to access a client's info from
a form that opens a clients subform - I am told that error 2538 has
occured and that this letter field could refer to more than one table
listed. and then error number 2950 appears. any ideas?

 

[boblarson]

1. The GoToControl Action on macros in Access 2007 is STILL AVAILABLE. Go
here to see how to get all of your macro actions to display:

http://www.btabdevelopment.com/main...dallofthemacroactionsgo/tabid/83/Default.aspx

2. If you have the same field name within two tables, or queries that are
linked together then you have that possibility of an ambiguous error because
Access won't know which one you want, so you have to be explicit:
MyTableName.MyFieldName.