Access Form: Show a list of all data associated with ID

[awap87]

Hi there,



I'm a bit out of touch with the front end features of Access (I mainly use the back end - tables, queries etc).

I was wondering if any one could assist on an issue I'm having with a form.

I have a table (I'll call it Transactions) and if Customer ID 1 made 5 transactions, this customers transaction details would appear 5 times in the table.

Is there a quick and easy way, on a form, when a Customer ID is selected, an element could return a list (or tabular detail) of details such as transactionId, amount, quantity - preferably in one box, each time the customerID is found in the table? So each transaction appears on its own row.

If anyone could offer any advice, that would be fantastic.

Many Thanks!

[ranman256]

Use parent-child forms.
You can make a Customer parent form, with transaction sub form.
show 1 c ustomer, and all his trans.
You can edit the transactions.

[awap87]

Use parent-child forms.
You can make a Customer parent form, with transaction sub form.
show 1 c ustomer, and all his trans.
You can edit the transactions.

Perfect! This did the job (it took me a few goes to get the settings right)

Thanks so much!