link form & subform for data entry

Joe Z

New Member
Joined
Mar 9, 2006
Messages
44
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
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
Thanks, I think there must be something wrong with the query. When I use the table for the subform it works corectly. Thanks again.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top