Search results

  1. S

    Combo box dependant Form

    Update: So I figured out that I was getting mismatch because I had relationships between "autonumbers" and "short text". I've created some more "ID" fields as "number" for relationships. Using form wizard (just a quick check to see if tables load in form together) i've managed to get rid of that...
  2. S

    Combo box dependant Form

    Hi guys! So I've spent the last week watching tutorial videos every evening after work and learnt a lot. I got to the point of having a form which worked as I wanted it too, however when I tried to set up forms which would run off a query to add additional information, or run reports, I kept...
  3. S

    Combo box dependant Form

    In the management table, I would only be linking 'Tail Number' to 'AinU Code' as they are directly relatable. Everything else was just for combobox drop downs in the form. Putting it all into one table is definitely a bad habit I've just brought over from Excel :D Did not realise that they...
  4. S

    Combo box dependant Form

    Thanks for the list of things to read Pat! I've attached what I made so far so you guys can see where i'm heading towards hopefully, still yet to tidy up the demands. Next would be to link AinU and TailNo boxes. Then finally a form/report? for people to search the table via 'Demand No' or 'NSN'...
  5. S

    Combo box dependant Form

    I've changed it all to one table, 1 form to submit new ones. Now to teach myself how to link combo boxes dependent on values, run queries, edits, and highlight stuff if a value xD Google and YouTuber here I come!
  6. S

    Combo box dependant Form

    Hey guys, Thanks for all the replies! I've tried adding "quotation marks" around ZZ382 etc, however then no Forms open at all. Looking at your demo arnelgp, i'm wondering if I am spreading too much out? And with Plog, you maybe right I might not need this many forms? What I have at the moment...
  7. S

    Combo box dependant Form

    Hello! I am very new to Access and VBA, so please bare with me if I am being dumb :D I am creating a database to track demands for items, place, update etc. So far i've been managing quite well just using YouTube and Google. However i've been stuck on this next part for 6 hours and am totally...
Back
Top Bottom