problem with combo boxes in Access 2007

  • Thread starter Trainer Barbara
  • Start date
T

Trainer Barbara

I converted a database from Office 97 to Office 2007. The combo boxes in the
forms did not work so I deleted them and then recreated them. The user
selects a specific row from the combo box and is taken to that specific
record. On one form, I continue to have problems. At first, the combo box
worked. However, when the user exists the form and at a later time re opens
the form, clicking on a line in the combo box produces the following error:

Return without GoSub

Do you know of any bugs with the combo box feature in Office 2007? Are
there workarounds because my solution of deleting the combo box and
recreating it on the form does not work?
 
S

Steve

There is an error in the code in the AfterUpdate event of the combobox.
Every Return in code must have a GoSub somewhere in the code above it. The
error message you are getting says there is no GoSub line. Maybe when you
recreated the combobox the GoSub line was omitted.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Top