Recent content by vent

Thanks everyone!

Hey guys, so I'm following Pat Hartman's great advise as best I can and made a junction table called tblAgencyProgramCodes and drawn out the relationships between both tables (screenshot below called tables). Have made a subform (screenshot below) and set to continuous forms. And below I...

Hi thank you for your detailed reply. Now my question is, the form's record source is a query. In the split form (screenshot below) there is a button the user can press that will open up this form. I had a previous problem where new records entered did not show up in the datasheet. To solve...

Hi all So in the screenshot below is a form users use to add new company information. The organization I'm with is a local community college and they monitor which companies work with the college. Certain companies or agencies if you will, will accept students from certain programs. E.g...

Never mind guys, I got it working. THank you!

I'm trying to post on here but it's not letting me. Something about proxy connection, I tried following the instructions but still no luck The SQL for the query the datasheet and form is built on is this: SELECT tblAgencyInformation.Agency, tblAgencyInformation.Subsidary...

I added this refresh button on the split form (frmAgencyLookup) and the on click property is [Event Procedure] and the code here is: Me.Requery The close button on the add new agency form (frmAddAgency) has an On Click property set to [Event Procedure] and the code here is: Private Sub...

Sorry you mean this bit of code should be in the frmAddAgency form? (See picture)

As a datasheet. It's record source is a query. The form frmAddAgency's record source is the main table itself

I got an error that said: Run-time error '2478': Microsoft Access doesn't allow you to use this method in the current view Private Sub cmdClose_Click() [Forms]![frmAgencyLookup].Requery// this part is highlighted DoCmd.Close End Sub

So after I hit save putting something like: Me.Requery In the On_Click property of the close button?

You mean like on the add new record form?

Hi all I have a split form where the top half displays some agency information and the bottom half is a datasheet that contains records with more details. I have a form button for users to add new records and when I went to fill one out, I hit save, then close on the form but whenever I try to...

It didn't but I will just delete it and replace it with another copy. I also work on splitting this database. Thank you.

Basically just function as a search bar that filters a datasheet (split form) based on whatever the user types in.