Search results

Hi, I'm trying to setup a form where a combo box that is limited to a set of results based on another value in the form. I have the query for the combo box set with the following criteria: [Forms]![main form name]![subform object name]![field name] This works great for the current...

I'm trying to create some pivot charts in an Access form, and I'd like the relationship between filters to be "OR" instead of "AND". Is this possible? Thanks!

Thanks for the replies. You're correct, the combo boxes (with value lists) are located in the table and not in the form. After reading the MVPS link, I can see why this generally bad practice. Thanks for the tips... problem solved!

I have built a form that inputs data into a table. A number of the fields have combo boxes, with the "row source type" set to "value list". When I view the table in datasheet view, the combo boxes function correctly. However, when using the form to input data, these combo boxes show up blank...

This seems so simple, but I can't find the setting I'm looking for.... I have a subform that is displayed in datasheet view. When using the form, it's common to scroll through the columns using the arrow keys until reaching the desired column. If you scroll too fast and reach the end of a...

That did the trick! Thanks for the great link.

Here's an attempt at describing the forms. Form1: --Has a combo box to select records from Source A (index = "storeID") and displays a subform connected to the same datasource (index = "storeID") --Has a button to open Form2 Form2: --Has a combo box to select records from Source A (index =...

Almost there.... This now navigates to the new form and finds the record as desired. However, the combo box no longer works to select records. It appears the ID field is being over-ridden by the previous script. Any ideas what's going on?

Thanks Bob. I now have my combo box working properly to select records, but am still not clear on how to set the "On click" property of a button to open Form2 and find the same record that was displayed on Form1. I currently have an embedded macro to open the new form "on click", but could use...

Hello, I'm relatively new to access/VBA, and am trying to use a button to open a new form (Form2). When the new form is opened, I'd like to find the same record that was displayed on the original form (Form1). Both Form1 and Form2 use a combo box with form/subform to select records. The VBA for...