Subform Dataentry Problem

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

Hi, the summary of my problem is the following: I'm having trouble opening a
form, with its subform having a new entry already created and data from the
main form put in it

Let me give you more table details:

tblClient: Client# and data, tblOrder: Order# and data , tblOrderProduct:
Products associated with that order

Form Details:

Main form frmBilling: Contains client information when it opens, it got to
display previously chosen client's data

frmBilling's Subform frmOrder: When opened, automatically add a new order
entry with the Client # in tblOrder.NumClient and a default order# when
frmBilling opens

frmOrder's Subform frmOrderItem: Allows to manually add one or more product
in that order with the frmOrderItem.NumOrder being the parent's form order
number


The way it currently works: frmBilling is opened after a search for a client
in another form. I pass the NumClient as openargs, and in the form load I
filter the frmBilling so that I have the correct client info displayed and
requery the subform. In frmOrder I assigned a function that returns the next
order number in the DefaultValue property if my NumOrder textbox.

The problem: When the frmBilling is opened, the subformOrder.txtNumOrder
displays the good order # but a new entry wasnt yet created (as if the value
is in txtNumOrder rather than in the NumOrder table field. Then if I try to
add a new product in the order, the subfrmOrderItem.NumOrder will not contain
the order# because no new order exist.

If I enter some data in the order before adding an item, a new order entry
is created and from now on, new items contains the order#

What I need: To be able to open the frmBilling displaying only one client,
no navigation or adding clients. frmOrder must have a new entry linked to my
client and with the new order# being provided by me thru a function call.
frmOrderItem works ok only if a new order exist so I believe there are no
problems there.

Thank you very much for your help!
.

Relevant Pages

  • Re: initialize form
    ... my analysis was that your subform is not set up properly, ... existing client record in the mainform, ... that is the basic form/subform setup: but the question is how to ... The problem is that once the form has been filled out with data entry ...
    (microsoft.public.access.forms)
  • Re: Subform Dataentry Problem
    ... Set the Data Entrry property of the frmOrder form to Yes, so it automatically opens at a new record. ... Use SetFocus on the Load event of the frmBilling form to move the focus to the frmOrder subform. ... I would not have a form based on the Client table implicated in the process of Order entry. ... I would have the Order form as the main form, and a combobox on the Order form for the entry of the Client that the Order pertains to. ...
    (microsoft.public.access.forms)
  • Re: Client/Server Application
    ... just one function of a client. ... need to produce a Windows-based "system" that has a number of data entry ... receiving are disconnected experiences; you may "send" hundreds of times, ... responsibility of the sender to re-establish communication and re-send the packet. ...
    (microsoft.public.vc.mfc)
  • Re: Counting unduplicate data
    ... "Marshall Barton" wrote: ... if a client has come more than once (i.e. more than one subform is ... attendance subform's Link Master Fields property would be: ...
    (microsoft.public.access.reports)
  • Re: Editing data on subform
    ... On the subforms table there is a multi field primary key. ... subform (Client). ... My client field in the client table is indexed: Yes (No Duplicates) ...
    (microsoft.public.access.gettingstarted)