Access Form

[KAcharya]

Hi there,



I have created a customer database for my small business. I have a form called "customer details". This is "view only" form, can not change customer details. I have added command called "edit customer details" to this form. When command button clicked on, it opens another form called "edit customer details".

What I would like to do is when I select a customer in "customer detail" form and if I want to make any changes to this customer, I press "edit customer details" and it should open "edit customer details" form with this particular customer's details.

However it is not happening. "edit customer details" form always opens first customer's details from the "customer" table.

Can anybody help me please.

[alansidman]

Suggest you post your code that is behind your command button to open the edit form. Can't help you unless we know what you are doing.

http://www.excelguru.ca/node/7

http://www.access-programmers.co.uk/...d.php?t=216578

Alan

[bbrazeau]

Hi See if this helps.(see attached database)

[KAcharya]

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<UserInterfaceMacros xmlns="http://schemas.microsoft.com/office/...InterfaceMacro For="CmdEditCustomerDetails" Event="OnClick"><Statements><Action Name="OpenForm"><Argument Name="FormName">Edit Customer Details</Argument><Argument Name="DataMode">Edit</Argument></Action></Statements></UserInterfaceMacro></UserInterfaceMacros>