Prev: Command Button to open a password protected excel spreadsheet
Next: How to clear the previous data
From: deb on 22 Feb 2010 08:16
Using Access 2003

I have a main form with tabs.
Within each tab I need a subform that is used to store links to attachments.

Is it possible to use the same form that I created for saving links to
attachments within each form on the other tabs?
If this is possible,
How do I change the row source in the AttachmentType field.
How do I change the WHERE clause for each form?
How do I make it change the attachment subform's combo box's row source when
user click on the specific tab?

Main Form is f001ProjectReview (PK ProjectID)
Tabs are Financial, Outages, Shipping and Contracts
Subform I want to use is f020Attachments (PK AttachmentID, SK ProjectID)
with a combo box called AttachmentTypeSubID

The current row source for the combo box is ...
SELECT t22AttachTypeSub.AttachTypeSubID, t22AttachTypeSub.AttachmentType,
t22AttachTypeSub.AttachmentTab
FROM t22AttachTypeSub
WHERE (((t22AttachTypeSub.AttachmentTab)="Financials"))
ORDER BY t22AttachTypeSub.AttachmentType;


Thank you in advance for your help.

--
deb
 | 
Pages: 1
Prev: Command Button to open a password protected excel spreadsheet
Next: How to clear the previous data