Search results

Paul, You were exactly right. I made the change and it worked as intended. Thank you for your insight. KMS

I have an unbound combo box that I populate using the following query: SELECT Customers.PartnerID, Customers.CustName FROM Customers WHERE (((Customers.PartnerID)=[Forms]![Partners-Detail]![Master_ID])) ORDER BY Customers.CustName; I get the correct values displayed when I hit the drop down...

Bob, Thanks. I was just trying the VBA option. I haven't written any VBA but the requery is very simple. I tried the same references I was trying in the Macro and they work in VBA. The lesson learned for anyone reading this is that if you want to access a control in a subform to do...

Thanks spikepl. That at least confirms that I am looking at the correct control name on the form. Anyone else got any advice what else I might be doing wrong?

Thanks guys for all of the pointers but I still can't refer to the controls that I need to. I've read all of the articles and used your suggestions as best I can but the path I'm using to the control isn't working. I'm trying to do a Requery from a macro. I am able to get it to work on a...

As best I can tell my form has the following hierarchy of controls. As you go down the list, the item below is a child of the item above it. Form - Partners-Detail Tabcontrol - TabCtL6 Page - Interactions Subform - Contract_Detail subform Combo Box - Customer How would I reference the combo...

Thank you, that is what I needed. KMS

Paul, I have Access 2007 and the setValue action does not show up in the list of actions I have. I looked elsewhere and found someone commenting as follows: I looked around and can't figure out how to access it since it doesn't show up. It sounds exactly what I'm looking for however. KMS

Is there a way to clear an unbound field on a form from a macro? My form takes input from unbound fields and appends that data to a table. I want to clear those fields and requery the DB after the append from a button. Is there a way to do this without VB code (I'm not great at VB)? Thanks...

Thanks Bob. Looks like I didn't have the syntax of the SQL quite right. Access didn't like the name of the table before the field name inside of the parenthesis. See below: INSERT INTO Contact_Detail (PartnerID, [Date], Customer, Description, Employee ) VALUES...

I put the following code in the query. INSERT INTO Contact_Detail ( Contact_Detail.Date, Contact_Detail.Customer, Contact_Detail.Description, Contact_Detail.Employee ) VALUES (Format(Forms![Partners-Detail]![Date_Ctrl],"\#mm\/dd\/yyyy\#"), [Forms]![Partners-Detail]![Customer_Ctrl]...

I created a button with an onclick event that was a Macro that invoked an OpenQuery. The query referred to was as follows: INSERT INTO Contact_Detail ( [Partners-Detail].[Master_ID], [Partners-Detail].[Date], [Partners-Detail].[Customer], [Partners-Detail].[Description]...

I have a datasheet that has a list of interactions with a partner in reverse date order (Newest on top). I did this because I didn't want to scroll to the bottom each time to get the latest interaction. How can I enter a new interaction without having to scroll to the bottom of the datasheet...

That did it. For some reason I thought it would requery with each record that I navigated to. Definitely not the case.

I am actually trying to base the options available in the combo box based on the data on the form.

"You'll need to requery the combobox (or reset its rowsource) in the form's current event and probably in the partner field's afterupdate event. " Thanks VilaRestal. Sounds to me like you are exactly right. I'll give it a try.

I have a combo box that allows a user to select the name of a partner contact. The combo box should only have those partner names that match the partner that I am currently viewing. I can get the combo box to either display all values in the contacts table or I can get it to just show the...