Ah, right .. works ok now but I have one (hopefully) final question ... Is there any way to make the filtered dropdown list (from the MS article on synchronizing dropdown lists) sort the items it contains?
Thanks again!
I have most of this working now, the only issue I am having now is some of my dropdown lists which are now linked together, previously would show the information when paging through records but do not show anything right now, I verified they are all bound properly with ControlSource.
Without...
I added the extra fields for paging through the records and they display ok, except now I have a droplist and a text field for each item which may end up being confusing for some of the users, but I will look at hiding/unhiding the element later on if you think that would be a viable solution...
I dont want the textbox to have the same value as the droplist, I want it to look up a value based on the synchronized drop-downlist created above.
What I have is a Group name, an Employee name, and a Employee ID number. Using the previous instructions I can select a Group which presents me a...
I figured out the error (had put the wrong variable) and it works great!
I have one other question, can I use a drop-list to update a textbox element in a similar manner?
I got the first part ok, all of the droplists now reflect data from the existing table when I scroll through the records.
Unfortunately I cannot get the synchronization to work. The DAP opens normally, but when I select anything from the Team (Group) drop-list, I get an error that says "Data...
Thank you very much, I was not aware this required a primary key, it works ok now for scrolling through, editing, and creating new entries.
As for the second part of my question, I have a 2nd table which has a Group id and Name relationship with this table.
Here's what I want to be able to do...
I am trying to make a DAP for data input into a table.
I used the wizard and it has the fields I want, I can scroll through them and view the entries, but they are not editable.
I read about changing the Page DataEntry property to True, but I still cannot select any of the editboxes on the DAP...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.