Adding record into the subform

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sansanee (sansanee_at_nospam.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 13:43:19 -0800

Hi,

I have a mainform with a drop-down list for ClientId and a subform that
display the schedule corresponding to the clientID. But I am trying to let
my client add a schedule into this query form as well. Can anyone help me
because I changed in the form setting to allow addition but still the error
came up and said that the record can not be added because of the
corresponding records in Client table.

Thank you in advance,

Sunny

Relevant Pages

  • SQL error
    ... I am attempting to permit the user to select 1 of 3 options in the display of database records. ... OptSchedule(0) is titled: ... The SQL statement worked before I included the sSchedule variable also. ... strSQL = "SELECT LastName, FirstName, ClientID, " ...
    (comp.lang.basic.visual.misc)
  • Re: Adding record into the subform
    ... > I have a mainform with a drop-down list for ClientId and a subform that ... > display the schedule corresponding to the clientID. ... > my client add a schedule into this query form as well. ...
    (microsoft.public.access.queries)
  • Re: Adding record to a subform in a query mainform
    ... > I have a main form with drop-down list of ClientID to query for schedule ... > data in the subform. ... > a subform without a corresponding clientID. ...
    (microsoft.public.access.forms)
  • Adding record to a subform in a query mainform
    ... I have a main form with drop-down list of ClientID to query for schedule ... I am trying to let the end user input additional ... schedule into the subform but I get the error that I can't add a record into ...
    (microsoft.public.access.forms)
  • Re: so close..I think
    ... I managed to get the name to display properly based on most ... >> first I have to read the clientid from the fourth field of the current ... > to retrieve the value at that location. ... > You could get a value at the proper point in your retrieval by: ...
    (microsoft.public.dotnet.framework.aspnet)