Search results

  1. N

    Trying to populate a text box from the choice of a combo box

    You are a saint pbaldy. That is exactly what it was. Thank you so very much
  2. N

    Trying to populate a text box from the choice of a combo box

    when I reverse them I get an '2113' error that 'the value you entered isn't valid for this field'
  3. N

    Trying to populate a text box from the choice of a combo box

    this is the code that shows with the debug Me.Department.Column(1) = Me.DepartmentID.Value
  4. N

    Trying to populate a text box from the choice of a combo box

    I have got it working now following Markk's instruction. But it still has error saying 'Object Required', though if I just hit OK it all works just fine as if there was no error
  5. N

    Trying to populate a text box from the choice of a combo box

    Here are screenshots of my properties for the combobox. Would you mind telling me if I am wrong somewhere.
  6. N

    Trying to populate a text box from the choice of a combo box

    I added that but it still throws a run-time error '3341' code.
  7. N

    Trying to populate a text box from the choice of a combo box

    Was this the only code you changed? I have been doing everything I can to make it work and just can't seem to get it.
  8. N

    Trying to populate a text box from the choice of a combo box

    After I removed the Control Source for the DepartmentID the textbox populates from the combobox, but the problem with that is it takes away the DepartmentID in datasheet leaving all of the DepartmentID's blank
  9. N

    Trying to populate a text box from the choice of a combo box

    I'm just not sure what I am doing wrong. I appreciate all of the help.
  10. N

    Trying to populate a text box from the choice of a combo box

    Now I have both of the fields showing up in the Department combobox, but it still isn't populating the DepartmentID textbox
  11. N

    Trying to populate a text box from the choice of a combo box

    Here is the database.
  12. N

    Trying to populate a text box from the choice of a combo box

    I do have the column count set to 2, and I took your advice and changed it to after update, but still no result
  13. N

    Trying to populate a text box from the choice of a combo box

    Sorry I didn't state the problem, which is that it is not populating the textbox. Are there any other settings that would need to be changed to go along with this?
  14. N

    Trying to populate a text box from the choice of a combo box

    I've been working on this database for about a week now and it is my only experience with Access so far so I don't know too much VBA yet. My problem currently is that I am attempting to Add a record to a database on a split form, and I want it so that when I choose the department via combobox...
  15. N

    Adding a new record to a table from a split form

    Here is a picture of the the form for further clarification
  16. N

    Adding a new record to a table from a split form

    I am attempting to create a form that has the functionality to search and to add a record all in a split form. I have the 'Search' portion working well, as well as the 'Reset' and 'Print Records' buttons. I had all of it working perfectly with the record source being a table, except for the fact...
Back
Top Bottom