How are ya Asspin. That was just what I needed. Spot on! One more question. Selecting the user from the combo box is now working, the other thing I would like to get it to do, is allow me to type a name into the combo box to create a new record.
Any idea here? Have a look to the NotInList event. Ok, I pulled up the help for that, I am guessing I need something like this? I don't even get the message box popup when I try to add a new user. Add them? Save Me! Undo End If End Sub. So it does! My bad! Once I have this set though, I have errors in my code. What am I doing wrong here? Hmm, you seem to be right, it doesn't look like this is adding to the table. Is their any other way to do this?
Save acDefault Here is my current code Save acDefault Me! This lets you default to the first value and rely on the value in the current list rather than hardcoding a specific value.
On a form with multiple Combo Boxes, you may want to make the selection in one Combo Box limit the choices in another Combo Box. To do this, add code to the AfterUpdate event of the first control that updates the RowSource property of the second control:. If the list is based on a table that is updated with new values after the combo box is loaded, the new values do not automatically appear in the list. F9 refreshes the combo box list with the current data. For data entry of addresses, we like to speed data entry and improve accuracy by forcing users to select countries from a combo box list, along with state if it's a country with a state list.
Additionally, we use a zip code lookup table to fill in city and state values. This improve accuracy by eliminating typos on city names and flagging wrong zip codes if the city doesn't match. Some zip codes have multiple acceptable cities. With a zip code lookup table from the US Postal Service provided by our Total Zip Code Database subscription , we can easily provide a lookup for city and state, plus add a Combo Box for selecting valid city names:. Microsoft Access within an Organization's Database Strategy.
Microsoft Access vs. How many simultaneous Microsoft Access users? Blaming Microsoft Access instead of the Developer. Microsoft Access Version Feature Differences. Split Database Architecture for Multiuser. Field Type Consistency. Table Normalization Tips.
Avoid Unnecessary or Duplicate Indexes. Replace Attachment Field Paperclip Icon. Avoid Decimal Data Types. Microsoft Access Query Tips and Techniques. Copy Command Button and Keep Picture. Resync Record in a Subform. Subform Reference to Control Rather than Field.
Add the NoData Event. Annual Monthly Crosstab Columns. Add Buttons to the Quick Access Toolbar. Collapse the Office Ribbon for more space. Avoid Exits in the Body of a Procedure. Shortcut Debugging Keys. Rename a File or Folder. Avoid DoEvents in Loops. Error Handling and Debugging Techniques. Error Number and Description Reference.
Basic Error Handling. Pinpointing the Error Line. Disable Design Changes. Remote Desktop Connection Setup. Address2, tblCompany. Address3, tblCompany. Address4, tblCompany. Address1; The problem I am having is that when i load a new record how to retrieve the data and automatically load the cmbComp and text fields. The cboOff combo box loads correctly as the control source for this is the offID I imagine there must be a way of setting the value on opening the record?
ItemData 0 Me. Column 2 Me. Column 3 Me. Column 4 Me. Column 5 End Sub Not sure what tod do?? Add a comment. Active Oldest Votes. Requery In the relevant Event handler. Probably "AfterUpdate" if I remember correctly. Loopo Loopo 2, 2 2 gold badges 25 25 silver badges 42 42 bronze badges. No sorry, its not Me. Requery, as far as i understand it that reloads the entire records.
What I would like to find out is; when i move between the records the controling cascading combo box, and the relevant fields that get updated by it are empty. I do not know how to populate these fields when opening a record on a form. Does that make sense??
0コメント