The db that I am developing (Access 2010 on Windows 7) consist of a main form with a tabcontrol. Each tab consist of a split form. Within the split form are combo-boxes with data based on a saved query. The issue is requerying the row source for the various combo-boxes when the record on the main form changes. Each of the tabs contain different data from the db tables. Each tab only uses one table. Each tab is linked to the main form thru an id field.
Query definition for the combo-box row source:
SELECT tblParcel.lngParcelID, tblParcel.lngParcelNum
FROM tblParcel
WHERE (((tblParcel.lngTPTID)=GETTPTID()));
The function GETTPTID() retrieves the ID which is updated every time the main form updates to a new record.
I am trying to use the TabCtl On Change to initiate the requery for the combo-box. Tried several approaches at a loss. The combo-box is used to list the currently identified property parcels used when sending correspondence. Not sure if I have explained the issue well enough? Any suggestions would be greatly appreciated.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar