Saving unbound fields on form to table

[lexygirl]

I am trying to save unbound fields to a table. I have the following forms



Enter payments
Fields - client number, first name, surname
Combo box - used to pick client.. I want the Enter payments form to be blank upon opening, I get this to work by putting in a filtering condition which can never be true, but then when I pick client off combo box no data is displayed… combo box is in form header

Bookings subform
Fields - booking id, b date, b resource, b type, b rate, b time slot, b cancelled, client id (FK)

Payments (pop up form)
Fields

Payment id auto number
Payment date default vale = date()
Sim duration entered by user
Payment amount =[sim-duration]*[text15]
Payment method drop down list
Client id =[Forms]![enter payments]![bookings subform].[Form]![client id]
Text 15 invisible field which holds the b rate from bookings sub form =[Forms]![Enter
Payments]![Bookings subform].[Form]![booking rate]

When I save the record payment amount and client id isn’t saved to the table. How do I get these values to be saved to the table payments… also when payment is saved for client, I want to be able to pass a value back to the bookings table (bookings subform) which I will add a field [booking paid for] Y/N so that clients with only bookings not paid for are listed in bookings subform.


Any help would be greatly appreciated…………

[Bob Fitz]

Hi

Why don't you use bound controls?

[alansidman]

Bob raises a good question. But in any event, here is a tutorial on how to accomplish what you are trying to do.

http://www.datapigtechnologies.com/f...rdsnocode.html

Alan

[lexygirl]

Hi,
thanks for your help, thats a great video would love to find more videos, haven't done access for so long and would love to learn more.... the fields i use on payments form are from the table payments, I thought because i changed the control source on payment amount and client id that they then became unbound.....
where would i put the =[sim-duration]*[text15] (currently in record source on data tab of field sim duration) and =[Forms]![enter payments]![bookings subform].[Form]![client id] (currently in record source on data tab of field client id so that it would just save like a normal record.

many thanks

[alansidman]

For more videos, click on the Datapig link in my signature block in the previous thread. Also, there are many on YouTube. Go to Youtube and do a search on access tutorials.
Alan