Updating data in a tab Form

[starogue]

I have a tab form sourced to 1 table with 4 tabs needing to get data from another table.

I have a combo box that looks up to one of the tables needed on the tab. How do I make the rest of the fields on that tab update once I've made my selection in the combo Box

 

[starogue]

attached database

I'm pretty new to programming in Access. I am using Access 2003. Heck, this is myfirst time ever creating an access db application. with that said, here is the database I'm having issues with. I truly need some help. My brain is actually hurting trying to understand what I'm doing.

Go to New or Edit Case

Click the Judge Tab

The Find Judge combobox look at table judges and lets the user select a judge from that table.

What I need to happen is have the information from the judges table populate the fields on the Judge tab in the mediation form.

Is this possible? Once I understand how to do it for the Judge's tab, I can do the same for the rest of the tabs. or is there a better way to do this. Someone please tell me yes then tell me how to do it. I will be in your debt.

 

[trucktime]

Populate

Starogue,

I played with your MDB a little bit.
In Design View, check the combox on the Judge Tab, look at the code in the AfterUpdate Event. It will show you how to autopopulate the fields on that particular tab. I made 3 fields working, you can easily ad the rest.

Good Luck

 

[lendinas]

hide background of the application

hello,

I would have a question...
I saw the databases prepared by you...how can I hide db tables and background of access in order to be able to send you only the forms?

 

[starogue]

Thank you!!!

lendinas

If I understand it correctly, how do I get the form to hide the tables in the background so the user only see the forms and work with the switchboard instead of the tables.

Trucktime

I thank you. I'll be checking it and I'm positive it will work. I wish you the happiest and rich blessings for the holiday season.

 

[lendinas]

hiding access db

dear starogue,

I was constrained to let sleep for a while my access application.
well, I tried to hide my access db and the rest from the window menu and by creating a startup macro.
But now, I want my tables back to make some modification and I cannot find them.
I am sending you my access db.
Can you please help me to get back everything and tell me how to put the tables somewhere in computer and create an exe with an icon for starting this application?

Thank you in advance,
waiting for your reply

best regards
Lendina