Results 1 to 5 of 5

Saving unbound fields on form to table

  1. #1
    lexygirl is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    8

    Saving unbound fields on form to table

    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…………

  2. #2
    Bob Fitz is online now MS Community Contributor
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    1,345
    Hi

    Why don't you use bound controls?
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



  3. #3
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Lake County, IL
    Posts
    1,994
    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
    If an answer has "resolved" your issue, then make sure to mark your thread as "solved." Did my answer help? Click on the '*' below.
    Relational Database Principles
    DataPig Access Tutorials
    Debug your Code​

  4. #4
    lexygirl is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    8
    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

  5. #5
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Lake County, IL
    Posts
    1,994
    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
    If an answer has "resolved" your issue, then make sure to mark your thread as "solved." Did my answer help? Click on the '*' below.
    Relational Database Principles
    DataPig Access Tutorials
    Debug your Code​

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Saving unbound feild values
    By John Saul in forum Access
    Replies: 1
    Last Post: 06-19-2013, 05:22 AM
  2. Replies: 1
    Last Post: 07-22-2011, 01:48 PM
  3. Replies: 1
    Last Post: 04-19-2011, 12:55 PM
  4. Replies: 5
    Last Post: 03-23-2011, 01:28 PM
  5. Calculations in Form not saving to table
    By ld8732 in forum Forms
    Replies: 1
    Last Post: 01-24-2011, 05:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums