Recent content by Aikistan

  1. A

    Using combo box to source two controls

    The Column Widths are 0.25";6.45";0.45" I played around with them to no effect. I've attached a Form View of what I'm doing/seeing.
  2. A

    Using combo box to source two controls

    Actually, I made that change to txtSponsorState and now cmbSponsorName is displaying the State value rather than Grantee. Bound column is still set to 2. edit: It's displaying the State but entering Grantee into the field. I need it to show Grantee.
  3. A

    Using combo box to source two controls

    Well, that was easy. <facepalm>
  4. A

    Using combo box to source two controls

    Hello again everyone! I have a form (frmSponsorEntry) for simple name/address entries into a table (tblSponsors). For SponsorName, I have a combo box (cmbSponsorName) that queries a table (lutblTEAMID) to use as its list. lutblTEAMID has fields TEAMID, State, and Grantee. cmbSponsorName...
  5. A

    Using value from one control as filter on another with a twist

    Okay, this now works perfectly to display the filtered list; however, when I choose a value from the list, the first column is chosen (lutblTEAMID.State), not the value of the Grantee's name (lutblTEAMID.Grantee). My revised entry query is (I took Mr. Hartman's implied advice and changed...
  6. A

    Using value from one control as filter on another with a twist

    I'm still hoping for North Dakota to become just Dakota...
  7. A

    Using value from one control as filter on another with a twist

    They're on the same form (it's a sub form). Where to add that WHERE, though? In the first combo's After Update?
  8. A

    Using value from one control as filter on another with a twist

    All, Thanks in advance for this. My new DB project has a lookup table I created to limit the selection of the State a project is in to a list. On form "subfrmDocumentEntry" I use a combobox that displays the StateAbbr (e.g., "GA") but the table I'm holding this in keeps the R4StateID (e.g...
  9. A

    Change AllowEdits based on y/n field value?

    [Solved] Change AllowEdits based on y/n field value? I know this is possible...I've done it before but I just can't remember how anymore since my mini stroke. I have two related questions about the following database. I have Form A and it has a subform B. A enters information about a sponsor...
  10. A

    Hello World!

    I'm an amateur at Access although I've created several databases in various versions over the years. The last one was in 2010 and I've since suffered a bit of memory loss, so I'm struggling now that I need to create a new one. Please be patient!
See more
Back
Top Bottom