Auto populating forms, followup

Hi, Thanks to all who responded to my earlier question on this topic.
I finally got the data entry form to work and populate the Client's
name and sales rep info from the client table, but the populated info
is not saved to the target BSR MASTER TABLE.

Here is my Control source for the Form:

SELECT [BSR MASTER TABLE].[ID], [BSR MASTER TABLE].[Date], [BSR MASTER
TABLE].[BSR Name], [BSR MASTER TABLE].[Client No], [client table].
[Client Name], [client table].[Sales ID], [client table].[Sales Rep
First], [client table].[Sales Rep Last], [BSR MASTER TABLE].[Contact
Name], [BSR MASTER TABLE].[Type of Contact], [BSR MASTER TABLE].
[Comments] FROM [client table] INNER JOIN [BSR MASTER TABLE] ON
[client table].[Client No]=[BSR MASTER TABLE].[Client No];

When I add a record, the info that I key is saved to the table, but
the Client info, though visible on the form, is not saved, the fields
are just blank in the table. Any suggestions?

.

Relevant Pages

  • Re: ComboBox Values to TextBox
    ... then in the Task text box Control source choose the field from the table ... The combobox is bound to the field and the value is populated ... The data in columnneeds to populate the field ... Bound field works great but I have now foun a need to have 2 fields ...
    (microsoft.public.access.forms)
  • Re: Changing the parameters of a form
    ... a forms record source is the table or query that the form is ... just put Available in the Control Source text box. ... I also tried to creating a new textbox, and making that control source equal ... But now nothing will populate, ...
    (microsoft.public.access.queries)
  • Re: Add
    ... It is populated based on some logic in the control source. ... And I would just like the "Closed On" field to populate the current date if ... MVP Microsoft Access ... I have tried the following in the afterupdate event but with no luck: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Add
    ... MVP Microsoft Access ... And I would just like the "Closed On" field to populate the current date if the status field changes to "Closed". ... That would be the AfterUpdate event of the CONTROL -- if you are using form events, it would not go in AfterUpdate, but in BeforeUpdate ... I'm pretty sure this is due to the fact that my "status" field has some logic in the data control source. ...
    (microsoft.public.access.modulesdaovba)
  • Re: ComboBox Values to TextBox
    ... I fully understand that you have to have a field bound to its record source to store data. ... All I am saying is that what ever I put in as code i the after update event of the combobox, ... then in the Task text box Control source choose the field from the table ... > The data in columnneeds to populate the field ...
    (microsoft.public.access.forms)