Results 1 to 6 of 6

link form & subform for data entry

This is a discussion on link form & subform for data entry within the Microsoft Access forums, part of the Question Forums category; I am trying create a form that has the main form as medbill containing vendor name, account number etc. I ...

  1. #1
    New Member
    Join Date
    Mar 2006
    Posts
    44

    Default link form & subform for data entry

    I am trying create a form that has the main form as medbill containing vendor name, account number etc. I also have a subform medbilldetail that has invoice number, description, etc. There are two tables, medbill & medbilldetail; medbilldetail has a field medbillID, numeric long integer. The tables are linked 1 to many from ,medbill's ID field to medbilldetail field medbillID (numeric long integer) I created a query that includes all of the fields from both tables.

    When I enter data, eveything is fine for the form (medbill data) but when I go to the subform I get the error linkmasterfields property setting has produced "The object doesn't contain the automation object medbill.

    I hope that makes sense. Essentially, I am trying to enter information into two linked tables, one as the mainform and the second as a subform on the mainform. I am new to accesss programming so I may be overlooking the obvious. Any suggestions on how to set this form ans subform to process this info?
    Thanks

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Location
    California
    Posts
    576

    Default Re: link form & subform for data entry

    Quote Originally Posted by Joe Z View Post
    I created a query that includes all of the fields from both tables.
    Are you using this query for your form/subform? Don't. Create separate queries for each table for the appropriate form: main form bound to medbill, subform bound to medbilldetail. Set the master/child links to the medbillID (if you've done everything right clicking the ellipsis (...) should populate these for you.

    hth,

    Rich
    Imagine a funny saying here.

  3. #3
    New Member
    Join Date
    Mar 2006
    Posts
    44

    Default Re: link form & subform for data entry

    I was using one query. Now I have each, form & subform, with their own query but when I try to set the master/child link I get "can't build links between unbound forms". What am I doing incorrectly?

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Location
    California
    Posts
    576

    Default Re: link form & subform for data entry

    The only time I get that message is when one or both of the forms are unbound. I may think they are bound but there's something wrong. Make sure to set each form's Recordsource property to the name of your query (or to the SQL statement that constitutes the query--it doesn't have to be a saved query). You can even dispense with the queries altogether and just put the table names in there in case your queries don't run right for some reason.

    hth,

    Rich
    Imagine a funny saying here.

  5. #5
    New Member
    Join Date
    Mar 2006
    Posts
    44

    Default Re: link form & subform for data entry

    Thanks, I think there must be something wrong with the query. When I use the table for the subform it works corectly. Thanks again.

  6. #6
    New Member
    Join Date
    Aug 2010
    Posts
    2

    Default Re: link form & subform for data entry

    link form & subform for data entry Microsoft Access. ... Any suggestions on how to set this form ans subform to process this info? Thanks. Joe Z is offline.
    DataEntry false during the. Save or Cancel, the subform insists on ... subform can cause it to loose its link to the parent form record,
    Other times, you'll need to base an entry in one table on data that's stored in another .... To link the subform to the main form, you must link a duplicate.
    Forms and Subforms: Master ID Key not carrying to linked Child ID Key .... The occurrences subform should allow the data entry person to add.


    _________________________________________


    Want to get-on Google's first page and loads of traffic to your website? Hire a SEO specialist from Ocean Groups seo specialist

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com