Creating Forms/Subforums

[dbalilti]

So I am trying to make a forum, and within that forum are three subforums.



The subforums are essentially controlled by three Tables which is controlled by the Job Number
I want to be able to select the job number on the forum and see information from each of the subforums (Phases of the Job Number)

I have attached the DB for analysis

So far I cant even get the information to show up for one subforum when i select the Job number from the ComboBox

Help Plz!

(Biggest problem, When I change comboBox to the Job Number, the subforum wont update with the info for that job #)

DB_pUBLIC.zip

[John_G]

Hi -

I can't open the DB (I have A2003), but the first question is: did you link the main form and the sub-forms correctly, using the Link Child Fields and Link Master Fields properties of the sub-form controls?

John

[dbalilti]

I checked, and Yes I did. I actually Fixed the problem by Combining the 3 Phases and I was able to make a combo box that when i select the Job Number the subforum shows all the phases.
But i have one Problem, When I select the Job Number, It changes the Record Job Number (I.E The Table Values for Job Numbers Change) I Just want to be able to use the Combo Box to Show me the Records, Not affect them in any way.

[John_G]

First, don't bind the combo box to a table field (control source property is blank). Then, after selecting a value in the combo box, use VBA to navigate to the required record in the main form; the subform should automatically show the right records. Here is an example from pne of my own databases:

Private Sub cboCountry_Name_AfterUpdate()
'
' Go to the country number field, then find that record
'
DoCmd.GoToControl "country Number"

DoCmd.FindRecord Me![cboCountry_name].Column(0), acEntire, , acSearchAll


HTH

John

[dbalilti]

Thankyou! I figured it out. But, as I fix one problem another one pops up lol!, Now when I change the combobox, everything changes accordingly, but I am able to change the fields of the form. If i change The form "Allow Edits" to "No" I cant change the combobox therefore I cant pull the data for it. Any idea?

[John_G]

Hi -

Easy - just set the "Locked" property to true for all the controls (fields) you don't want to be edited. Setting Locked to true does not prevent VBA from changing the data in those fields.

John

[dbalilti]

Awesome! Thankyou!, That enough this week lol, My boss will be fairly happy now