Link to home
Create AccountLog in
Avatar of Claudia Carlotti
Claudia Carlotti

asked on

MS Access help

I have an MS Access form about Purchase Orders (PO) with table-linked subform (for detailed items).  I have a dropdown that shows PO number (Autonumber-PK) and auto-load all associated values to the form.  What I want to happen is load a recordset using the dropdown, click a button Add New, and use the current loaded values as data but just changing the PO number (of course automatically since it's auto number)?
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Claudia Carlotti
Claudia Carlotti

ASKER

Oh my my, I didn't notice that a "Duplicate Button" on the wizard exists!  Sorry, my bad but thanks a lot for the help!