Quick SQL Query question.

[Suoipoc]

Ok, so I have two forms, from two query that are from two tables. Up untill this point there has been no reason to link them. One of them houses student information for our program, and the other hosts clinical placement sites. Recently we have decided to have a section of the form that shows where the students are placed, which is not difficult, what is difficult is that the powers that be would like the dates that the site licenses expire to also be displayed. Now, I know how to join tables, and I have successfully done this in a query, and I have even successfully made the dates appear in the form. my problem is that I can't make the dates appear, and allow myself to edit the form. all the fields become locked and can not be edited.

I'm sure there is a way around this, but I have no way of knowing even what to search for.

Summery
Table 1: Contacts
Table 2: Sites
Query 1: Contacts Extended
Query 2: Sites Extended
Join: Contacts Extended. Site Placement with Sites.Site name

Thank you for your help.

[orange]

Can you provide a picture (jpg) of you relationships showing tables and fields?

[Suoipoc]

Here is the picture of the relationships, I also opened the form (ereased personal information) in order to show that in the lower left of the screen it reads: This recordset is not updatable.

Thank you for your help, let me know if there is anything else I can post to help.
-Rusty

[orange]

This link may help. It identifies things that make a recordset non updatable.
http://allenbrowne.com/ser-61.html

[tdecker81]

Please don't over use them but dlookup might be a simple way to bring in a single slightly related field. It won't be editable. But the rest of your form should return to it's normal behavior. Use a textbox and set the controlsouce to the dlookup for your field. Since it's now not part of your main form recordset it will begin working again. Once the linking field on the form changes this box will automatically fetch the matching record from the secondary data source. Check it out see if that helps. Post back your answer and flagged it as solved once you have something that works. http://www.techonthenet.com/access/f...in/dlookup.php