Showing ALL RELATIVE FIELDS in sub form

[mopat]

I actually Dont need to do that last part but I really do appreciate your help!

by any chance do you know how to make the file executable without opening access? I will post another forum for that But you seem like you have extensive knowledge with Access.

 

[vbaInet]

1. Save the Record Source of the subform as a string variable in the click event of your button
2. Remove the Record Source from the subform property
3. Before you requery, you set the Record Source to that variable then requery.

 

[vbaInet]

I actually Dont need to do that last part but I really do appreciate your help!

by any chance do you know how to make the file executable without opening access? I will post another forum for that But you seem like you have extensive knowledge with Access.

Perform a google search for Access 20XX Developer Extensions, where XX depends on your version of access whether it's 2003 or 2007. It isn't an executable as such but it performs the job. Also look into Access Runtime. There's some information about this on the forum as well. Try using the Search feature on the forum.

 

[mopat]

thank you sir

 

[vbaInet]

You're welcome.