Select sheet from a drop down control box (subform embedded in the form)

[britney]

Thanks to my previous thread, https://www.accessforums.net/showthread.php?t=75440, I was able to create a form with a subform. Now that I have linked the two with a master/child relationship, my drop down combo box doesn't let me pick another sheet.




More details for context -
Table 1 - a list of departments (with all unique names) and additional comments with details like address/location/phone number etc.
This data is on the main section of my form. I have a combo box with all of the departments. I would like to be able to click the department off of the list, and have Access open the sheet with all of the details on that department.

The lower portion of the form holds a subform. This pulls data from Table 2 - a list of providers, with the department they work in/more information on that provider.

The department listed as the link between the two, table 1 as the master, table 2 as the child. .

I can use the arrows along the bottom to switch to the next department, and the subform allows me to use those arrows to flip through the various providers in each department.

I can click on the department drop down and the departments display, however I cannot actually pick one of the departments off of the list.

Thank you in advance! Please let me know if I need to provider more details or context.

[isladogs]

It sounds like the subform is read only OR you have locked the subform or individual controls.
Can you alter anything in the subform?

[britney]

I can alter things in the subform- I can type in the subform and override data that it pulls form the table.

[isladogs]

In design view check the following for that combobox
1. Is it set as Locked =Yes?
2. Look at the sql for the row source in datasheet view. Is that editable?

[Gicu]

Can you post the code in the AfterUpdate event of the combo-box? If you could upload a stripped down sample of your db with the form(s) in question it would make it much easier to spot the problem.

Cheers,
Vlad

[britney]

isladogs -
1. In the form, looking at the property sheet in design view, it is set to Locked? No.
2. The SQL.. I think this is only visible in the Query of the subform. I can edit this. Is that what you meant?

[britney]

Gicu - I don't think I will be able to post a version of this, even stripped down, unfortunately. I do realize it would be a lot easier that way though, and I appreciate your assistance.

Looking at the property sheet for the combo box in the design view of the form, the After update event is blank. Should it not be?

[Gicu]

If you want to use a combo-box to navigate to your desired department record you need to add another one somewhere on your form and use the build-in wizard to do it; it will add code in the AFterUpdate event to use bookmarks to find your record and go to it. Looks like the existing combo box you have is simply a bound one to your department field and it is not "programmed" to do anything other than displaying the department from its control source.

https://support.office.com/en-us/art...b-b0f71a90c329

Cheers,
Vlad

[isladogs]

2. The SQL.. I think this is only visible in the Query of the subform. I can edit this. Is that what you meant?

No. Make a backup of your db.
Then copy the sql and paste it into a blank query as a test.
Run the query
Can the records be altered. Can you delete or add a record?

[britney]

*double post, please disregard

[britney]

After doing some more digging, and using Gicu's link, it appears that my form is not bound to my table, which is why I do not get the option to "Find a record on my form based on the value I selected in my combo box/list box" when I add an additional combo box to my form. I was able to switch it to a bound form, and add a new combo box with the setting enabled. Now I am working on getting my list of departments alphabetized

Thanks for your assistance on this!