Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Programmatically add records to Ms Access subform fields.?
Guys need your expertise.
I'm trying to put up a "Financial Transaction Form".
This form has a sub form.
Main Form : contains Transaction Details
Sub Form: contains Payment Details (Payee name and so on.) linked by Transaction number (TrxNum) from main form
My question:
I would like to add the transaction number (TrxNum) from the main form to the "trx-num-field" (hidden field) on the subform for every new payment (row) is entered.
how do i do this?
An Easy way to understand the form:
Main Form : for Transaction Type, Category Type, Transaction Account, Payment Mode
Sub Form: Payee Name, Sub Category, Amount
(mostly used for Split Payment transaction) ... and guys this is for a church..please need your help
AndrewL, sounds good. will try it.. but how do i enter values for other hidden fields in sub form which are not primary keys?
2 Answers
- Andrew LLv 71 decade agoFavorite Answer
The subform will only work if you have TrxNum as a primary key (autonumber) in your Transaction table, and as a foreign key in your Payment details table.
Just go into form design, double-click on the subform properties box (top left corner of subform). If the field list isn't visible, click on the field list icon). Now drag the TrxNum on to the subform (default control will be textbox). It doesn't matter where, it won't be visible. This will update as soon as you put data into your subform.
Right-click on TrxNum, Properties, set Visible property to No.
If all of the above doesn't work, it may be easier to use the subform wizard, which opens when you click on the subform control. This will take you through the steps needed to link your subform to your main form.
- Anonymous1 decade ago
Use an INSERT query in VBA.
