Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GotoControl throws 2046 error

Status
Not open for further replies.

tbeckman1

Programmer
Mar 11, 2008
3
US
I have a form with 3 tabs and a combo box with current records on the top called a List ID. When the combo box is changed the record on the first tab is to be refreshed with the current selection data. It is on file since the selection on the top only has records on file.
I have a macro that has GotoControl action with the receiver being Forms!FrmAfterCare!PatientID. This brings up the macro screen and a halt button. This throws an error 2046. Control does not exist or is not available.

Problem #2.
For new records I use the bottom of the screen record to retrieve a blank form. Patient ID is another combo box with a list. Limit to list = no, auto control = no. When I try an key in a value, I receive an Item not in list. It looks like it does not take the data entry.

Any thoughts? All help is appreciated.
Terry
 
I wish I could put a picture of the screen here as it will help explain what I am looking at.
I will try and make myself clearer on this.
1. At the top of the form is a combobox the lists current keys in the main file. It is used for selecting and moving between records.
2. There is a header information record starting with a patientID under this. This is where the patientID I am trying to change resides.
3. Under that there are three tabs and some buildin subforms on that thrre tabs for data entry.

I am having two issues.
1. I have a macro attached to lost focus on the top combobox. This is for users that what to move to a different patient.
The first step is a gotocontrol on the patientID. This is getting a 2046 error with the gotocontrol issue. I have also tried setValue on the patientID with the idea of running a query to fill in the rest of the record. These have all failed with versions of the 2046 error.
2. The PatientID combobox has limit to list = no and AutoCorrect = no and when I do a manuel entry I receive a - 2237 error and the message comes up that entry not in list.

I have had problems of the serverity one other time and I remember having to destroy the forms as some bug or system had corrupted the form. This would take a little longer than I would like to rebuild so help would be appreciated.

Terry
 
Made one error on last entry. The event that changes the screen from the first combobox is an onclickevent.

Sorry for the mixup.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top