Results 1 to 2 of 2
  1. #1
    HelenP is offline Novice
    Windows 2K Access 2000
    Join Date
    Oct 2010
    Posts
    16

    Silly question

    Hello

    This is going to seem like a silly question with a very simple answer but I have completely forgotten how to do it.

    I have two tables:
    Customer
    Action

    I want a form that allows the user to enter a customer ID and view the action that relates to that customer. I want the action to appear in a combobox so that if they need to they can change it. How on earth do I do this?!!?

    Thanks in advance

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    the traditional approach is to make a Customer form, sourced on the Customer table.

    then make an Actions form, sourced on the Actions table

    then insert the Actions form to be a subform within the Customer form.

    then add into the page header of the Customer form - a combobox that will allow the user to easily select an existing customer.

    hope this helps.

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

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