Ms access rowsource not updating

For information about entering new data in a database, see the article Add one or more records to a database.Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.Instead, a typical Access database is a a collection of tables, plus a set of objects built around those tables — forms, reports, queries, and so on.

As you proceed, remember that updating data is not the same process as entering new data.

The first field is "Sector." The second is "Industry." The values in the "Industry" combo box list will be different depending on which Sector is selected. ......[cbx Sector ID] is different than when I'm using the form - because I have the form embedded in a Navigation Form. However, when I'm using the form in the navigational panel, it needs to say [Forms]! Risk Type could be "percent based" or "specific amount." Depending on which is selected, I want Risk Value to be formatted as a percent or as currency. However - again - Set Property doesn't appear to allow changes to Format. I would suggest you make a home page instead of the navigation/subform.

Currently, when a user changes the Sector value: The Requery of Industry works because the Row Source looks at the INDUSTRY_TBL and grabs Industry ID and Descr where Sector ID = [Forms]! Therefore, if I'm just opening THIS form in design view, the Row Source of Industry ID needs to say [Forms]! Is there a way to do this in Macros that anybody knows of (straight forward OR workaround approach)??? The home page would have buttons that then use the onclick event to fire a macro that opens your form.

This solution is best for simple lists where there is only one field, such as choosing a category.

You must set the combo's Limit To List property to Yes, or the Limit To List event won't fire.

Search for ms access rowsource not updating:

ms access rowsource not updating-50ms access rowsource not updating-52ms access rowsource not updating-40

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “ms access rowsource not updating”

  1. “Taken from the dedication in my debut novel Exactly 23 days. For women everywhere: When you know you are finally mended, spread the word, hold out your hand, share some love from your heart and some laughter from your soul and be there for a new member of the sisterhood who needs your help.