Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007

    Red face Unanswered: About Access Form

    Actually im designing a simple access database with single table. n i'd like to make a datasheet view form where i can filter the data using combobox and command button. i make a form were i put combo box n command button n put sub form of main data. but i cant' get idea how to filter that sub form using command botton given by combobox criteria.if anybody can help me i'll be greatful. n one more how's it possible to lock the current record on a form applying the checkbox.if checkbox is clicked nobody can edit that record except administrator.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    sounds a little bit homeworkish to me.. what have you tried so far?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2007
    Provided Answers: 12
    I'd suggest a good use of dynamic SQL in VBA.
    AfterUpdate event of a combobox can be used to re-write the row source of say, a listbox. Basically you want to change the SQL every time you change your combobox value, right?
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts