Recent content by zarcoff

  1. Z

    combobox column property problem

    I have changed the combobox to a single column combobox and it seems to be fine without the column property. Not sure why it was set to 2 column combobox in the first place. So I have it working thanks if you've looked this and thought about it.
  2. Z

    combobox column property problem

    Hi All, I am trying to populate a 2 column combobox with the content of a record from a recordset. The user selects the relevant button on a sub form and the main form populates with the selection. For some reason I keep betting errors and I just don't know why. Can anyone help the debugger...
  3. Z

    AddNew Method Error 3027

    Hi Smig and Namlian, The userform had a subform in the footer. I have just removed it and it has started working. Thank you so much for responding. So I know what is kind of going on and I will try and work it out from there. Apologies for such a school boy error... but thank you very much...
  4. Z

    AddNew Method Error 3027

    Hi All, Thank you for any help in advance. This is doing my head in. It was working yesterday but today it is not. I am using VBA to add a new record to a linked table. The steps I have taken so far are: Copy the DB to my C drive. Unlink the network DB and relink all the tables to the...
  5. Z

    Query results based on 2 form control values

    Hi All, If anyone can help me I would be so appreciative. I have 2 form controls one a combobox and the other a text box. The text box helps select the site (txtLocation) where the user can enter part of the name of the site and all sites with those characters are returned. I've done this by...
Back
Top Bottom