Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. marc2982

    Problem with BeforeUpdate and AfterUpdate

    OK I understand. No, the combo box is unbound. I think I will try and fake it with a variable or hidden textbox or something. Thanks again for the help. :)
  2. marc2982

    Problem with BeforeUpdate and AfterUpdate

    Thanks for the response guys! traingamer - That makes sense, now I know how it works! Remou - I tried using cboProjects.OldValue, but it still gave me the new value, not the old one. Is there any way to do it without cancelling? Thanks!
  3. marc2982

    Problem with BeforeUpdate and AfterUpdate

    Hi guys, I have a combo box named cboProjects. In it you can select either One or Two, with the corresponding IDs 1 and 2. The code I have is this: Private Sub cboProjects_AfterUpdate() MsgBox "AfterUpdate: " & [cboProjects] End Sub Private Sub cboProjects_BeforeUpdate(Cancel As Integer)...
  4. marc2982

    Complicated table join with subquery

    Hi Guys! Thanks for the responses, sorry I didn't reply earlier, I was away. I figured it out; for some reason I assumed that the tables were joined through the field wkpkg (I didn't design the database), but they actually weren't! It turns out I was doing things right, and once I used the...
  5. marc2982

    Complicated table join with subquery

    Hello, This db I'm working on tracks the latest revisions of drawings. Multiple drawings fall under a work package, and multiple revisions of a drawing are present (listed 1, 2, 3, ...). I want to pull information about the latest revision of a drawing, including the drawing number, the...

Part and Inventory Search

Back
Top