Search results

Perfect, thank you :)

Sure thing, thanks JHB

Yeah, the data is going to the right table.... It's strange though: When I enter the data into the popup form I then close the form with a button to go back and check to see if the record is showing up in the combobox on my main form. If the table in question is open I notice that no record...

I have a combo box based off of a query of a table that I'm trying to tell to requery the list it provides each time it's opened. The user may need to add new records to the table sporatically (through a pop up form I've created) so I need for them to be able to have live data each time they...

Strange... I wonder why. I usually use Labels instead of buttons because I feel like I can control their appearance a little more easily. But in this case especially a button will work just as well. Thank you for your help :)

Sure thing. The form in question is: subfrmPlants Thanks again!

it is Numeric. It's an auto incrementing primary key for tblPlants. The value that shows when I place a breakpoint, regardless of which record I've clicked is 1. Thanks again!

I'm using the following code to allow the user to pick a record from a continuous form and edit it in a new window. For some reason my where condition isn't working properly as the edit form always opens to the first record instead of the record associated with the "Edit" button that was...

I figured out how to do this using access find unmatched query wizard: Query1:

I use access 2010. I have a form that allows the user to assign products to operations. Each operation can produce multiple products and each product can be produced at multiple operations. I manage this many-to-many relationship through the use of a third table that stores primary keys for...

oh also, that sample database worked perfectly. It was clear and simple to deconstruct and make work for my database. Thank you very much :)

One more question: do you have any suggestions for preventing users from being able to select a product once it's already been been added to an operation to prevent duplicate records from being created? I currently have the operationID / ProductID combo set as a primary key so the user does...

I think that's exactly what I'm looking for, Thank you Mr. Baldy :)

Hi forum, I'm using access 2010. I want to put some code behind a button that will allow the user to add selected products in a listbox to which ever operation is selected in a combobox by creating records for each product / operation combination in a third table: tblProducts tblOperations...

Access 2010 windows 7 The database I'm working on stores product records. To help the user narrow down which product they want to use, the navigation form has a listbox that looks to several combox values to filter the records it displays. As the user selects values for additional comboxes...

oh man, Ok i see the problem now, Thank you :)

How can you tell the sub is in frmManageDatabase?

the control is on the form: frmNavigationPane

Compile the VBA code and it will highlight the section of code in question. The control in question is on the form: frmNavigationPane. Let me know if you have any questions, thanks!

Sure thing :) Here ya go!