If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide duplicate fields on a continuous form
Hi I wonder if someone can help me please with a problem that's been baffling
me for days. Basically I have two tables, one that shows different departments, the other shows invoices allocated to that particular department. They are linked via an InvoiceID using a One to Many relationship. What I would like to do is to create a continuous form which shows all the invoices allocated to the Departments, but without showing a duplication of the department name. e.g. DEPARTMENT INVOICENO. Wages 1 2 3 Personnel 1 2 I know that this can be done relatively easy on a report by hiding duplicate values, but can anyone offer any guidance please on how this can be done on form? Many thanks Chris -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Hide duplicate fields on a continuous form
You can do this if you use a form and subform.
The main form is for the department, the subform shows all the invoices for the department. Use a combo box in the main form for the user to select the department. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "hobbit2612 via AccessMonster.com" u27332@uwe wrote in message news:a2a5e43776a84@uwe... Hi I wonder if someone can help me please with a problem that's been baffling me for days. Basically I have two tables, one that shows different departments, the other shows invoices allocated to that particular department. They are linked via an InvoiceID using a One to Many relationship. What I would like to do is to create a continuous form which shows all the invoices allocated to the Departments, but without showing a duplication of the department name. e.g. DEPARTMENT INVOICENO. Wages 1 2 3 Personnel 1 2 I know that this can be done relatively easy on a report by hiding duplicate values, but can anyone offer any guidance please on how this can be done on form? Many thanks Chris -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Hide duplicate fields on a continuous form
Jeanette's suggestion is dead on here! This is the classic form/subform
scenario. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
#4
|
|||
|
|||
Hide duplicate fields on a continuous form
Jeanette and Linq,
Firstly, thank you both for replying. You are both spot on. The problem I have is that I am trying to mirror a job which used to be done in Excel. The form will be used almost as a Working sheet so I need all the data to be on one screen as a list of information. I had thought of breaking this down to the scenario you suggest Jeanette, but this obviosuly means that the user would have to click through the Departments and hence would be diifficult to make a comparison between the Departments. If it can't be done then I may have to have a bit of a rethink. Many thanks to you both for your time and trouble. Regards Chris Jeanette Cunningham wrote: You can do this if you use a form and subform. The main form is for the department, the subform shows all the invoices for the department. Use a combo box in the main form for the user to select the department. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia Hi I wonder if someone can help me please with a problem that's been baffling [quoted text clipped - 31 lines] Chris -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
Thread Tools | |
Display Modes | |
|
|