link form & subform for data entry

[Joe Z]

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

 

[revans]

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

 

[Joe Z]

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?

 

[revans]

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

 

[Joe Z]

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

 

[chrisadam]

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