Search results

  1. G

    add 1 to last fileid

    hi all i have a fileid that i dont want to make a autonumber, but i want to act like an autonumber ,take the last id and add one when you choose new record only on a form with a subform. thanks in advance
  2. G

    Ucase help

    hi all I have a form that has textboxes, a combox and a subform, when i complete a record, I will like everything to capitalized in the table but I can't seem to figure out how to do this on the subform fields. I tried the ucase function for the after update but the subform doen't have an...
  3. G

    Form help

    I have a form with a combobox when CHOOSE A SPECIFIC NUMBER 008, 3 new boxes become visible, the problem is when I move to a new record I want the boxes to to become invisible again I have in form load for them all to invisible so they start out invisible but if that number is choosen then they...
  4. G

    forms and combo boxes

    Hi, How do i use a combo box to list all the records from a particular field so that when you select a item from the list it then populates other text boxes on the form relating to that particular record? For example, if i have a customer table and i have 100 records. I want to put all the...
  5. G

    Form Data

    I Have A Form With A Combobox When I Choose A Record Form The Box The Matching Info From The Table Populates A Textbox Example I Choose The Acct Number From The Box And The Company Name Goes In a Textbox looks like it is fine on the form My Problem Is That When I Look At The Table The Company...
  6. G

    runtime error 94 invalid use of null

    combobox help hi all i created a form from a table with 3 columns . I have a combo box on my form that is populated from column 1, and a textbox that is populated from column 2 when you choose a record from the combobox but the third textbox keeps generating an error - runtime error 94 invalid...
Top Bottom