Results 1 to 2 of 2
  1. #1
    siema24 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2017
    Posts
    22

    Default search for a value in a form depenting on edited value in another form

    Hi,
    I'm wondering how to improve moving between two forms within my navigation form. Let me show you a simple example:

    I have two forms:
    1. "Customer" form where user creates customer and his ID
    Click image for larger version. 

Name:	1_customer.png 
Views:	7 
Size:	3.2 KB 
ID:	28008




    2. "Service" - split-form where user assigns services to a customer. Customer fields (id and customer name) are read-only fields.
    Click image for larger version. 

Name:	2_service.png 
Views:	7 
Size:	10.6 KB 
ID:	28009

    What I'm trying to do is to auto set id,cusomer in "service" form depending on last customer edited in "customer" form.
    So, for example, if user creates customer no. 4423 and then switches to form "services" I want this exact customer be set automatically so user can add srvices without searching for a customer that he has just created.
    Do you guys know how to deal with this issue? : ) thanks!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    In The services subForm design, put the CustID, and service fields.
    then set the subForm properties:
    set parent field=CustID
    set child field=custID

    then entries in the subForm automatically belong to the Customer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Lock form to the record being edited
    By joecamel9166 in forum Forms
    Replies: 3
    Last Post: 03-24-2016, 03:09 PM
  2. Replies: 5
    Last Post: 02-20-2014, 11:05 AM
  3. Replies: 10
    Last Post: 08-02-2012, 08:32 AM
  4. Devil's form can not be edited!!!
    By albe_ACC in forum Forms
    Replies: 3
    Last Post: 10-26-2011, 02:38 PM
  5. form not letting records be edited
    By stuart rose in forum Forms
    Replies: 3
    Last Post: 09-02-2009, 04:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums