How to re-read database for record with a key passed as an argument?
I have two forms: one a list of Products; and second, an edit page of additional Product information. I have an event on On Dbl_Click on the List page with the following code:
DoCmd.OpenForm "Product_Edit", acNormal, , , acFormEdit, acDialog, Product_Nbr.Value
While I am able to see the Product_Nbr Argument being passed into the Product_Edit form, I'm not able to have this second form display this particular record. It only displays the first record in the Product table.
How to I tell Access to re-read the product table based on the Product_Nbr being passed into it?
Thanks....
Andre.
I have two forms: one a list of Products; and second, an edit page of additional Product information. I have an event on On Dbl_Click on the List page with the following code:
DoCmd.OpenForm "Product_Edit", acNormal, , , acFormEdit, acDialog, Product_Nbr.Value
While I am able to see the Product_Nbr Argument being passed into the Product_Edit form, I'm not able to have this second form display this particular record. It only displays the first record in the Product table.
How to I tell Access to re-read the product table based on the Product_Nbr being passed into it?
Thanks....
Andre.
3 Comments
Comment
Hi Andre,
You are sending in Product_Nbr as an OpenArgs parameter, which is available to the called form but nothing else is done with it automatically. It sounds like you want to use the WhereCondition parameter instead, which is the fourth one. To keep everything clear, I recommend using named parameters instead of counting commas. So, your statement will look something like:
DoCmd.OpenForm FormName:="Product_Edit", WhereCondition:="ProductNb
More help on the OpenForm command's parameters:
https://docs.microsoft.com/en-us/office/vba/api/access.docmd.openform
Hope this helps,
Armen Stein
J Street Technology
You are sending in Product_Nbr as an OpenArgs parameter, which is available to the called form but nothing else is done with it automatically. It sounds like you want to use the WhereCondition parameter instead, which is the fourth one. To keep everything clear, I recommend using named parameters instead of counting commas. So, your statement will look something like:
DoCmd.OpenForm FormName:="Product_Edit", WhereCondition:="ProductNb
More help on the OpenForm command's parameters:
https://docs.microsoft.com/en-us/office/vba/api/access.docmd.openform
Hope this helps,
Armen Stein
J Street Technology
Recommended Posts
So this year I decided it was really about time I applied for the
@vExpert subprograms, and guess what! I'm in! So Thanks to our Programme Manager![2024-vExpert-PRO.png]()
![2024-vExpert-vSAN.png]()
![2024-vExpert-vSphere.png]()
![vexpert-badge-stars-2024.png]()
![vexpert-badge-year-2024.png]()
@vCommunityGuy and Sub Programme Business Units!
@vExpert subprograms, and guess what! I'm in! So Thanks to our Programme Manager
@vCommunityGuy and Sub Programme Business Units!