#Name on Form

[BartK]

I have a form in which I would like to save some information into a table. This is the first time that I've dealt with multiple tables. I can get half of the form correct and everything is good there. I just can't get the other half of my form, which is looking to store information in a different table to work. I've tried to redo it in the control source several times, but I have had no luck.

Is this something completely simple and I'm overlooking it or is there a lot more to it? Thank you. I will attach my db as well as a pic so you can see what I mean. Thank you all.

 

[JHB]

The record source for the form need to include the fields you want to use in your control source.
Use a query for the form's record source.

 

[BartK]

JHB,
Thanks for the response, I am going to attach an image to this post and please let me know if I'm getting close. I didn't even think of making a query do the work.

 

[JHB]

JHB,
Thanks for the response, I am going to attach an image to this post and please let me know if I'm getting close. I didn't even think of making a query do the work.

Sorry, no you are not.
Create a new query, add all the needed tables into it (in the picture you show you have only table Equipment), and draw the relationship between them like you do in the relationship window.
After that you pick out the needed fields or all fields.

 

[missinglinq]

I cannot run your file, I assume that you're using 2010 or 2013, but multi-table queries, as a rule, are Read-Only (for the reasons why see Allen Browne Why is my query read-only?) and you stated that you want to use this Form for data entry into Tables, plural.

The best way to sddress this kind of thing is to use a Main Form and one or more Subforms, with each only having a single Table as its RecordSource. Exactly how you set this up depends on your data model which, as I said, I cannot access because I'm running 2007.

Linq ;0)>