Combo box help

[wizz_darlo]

Hi guys,

I know that there are a few posts on topics similar to this but because of my serious limitation of having no skill with VB code I can't tailor the replies to suit my needs.
Here's my problem...
I have a form which is used to raise reports and then send them out. I have figured out how to code the buttons to do this part for just the record shown on the form.

Now what I need is someone to choose a "System Number" out of a combo box and this record's data be displayed on the form. This part is easy because the wizard can do this for me. However the problem arises because there is more than one record for each System Number...ie 3243 01, 3243 02. The '01' and '02' are stored in a field called Report Number. I would like the combo box to allow me to select the system 3243, report 02 but when I do it just shows report number 01 for the system.
How can I make sure that the combo box refreshes to show each different report of each system when I choose it on the combo box??

I'm sure that this is quite a simple task.
If I really wanted to complicate things I would ideally want the combo box to pop up a new form which I have made and show the details for the system selected and any new data entered on the popup form to be saved in the original tbl1!!
But I think I'd better stick to sorting the first bit out.

Any help would be very much appreciated. I hope to learn from people's answers and one day be able to help newbies like myself out!

 

[quest4]

You might try this:
Private Sub Form_Activate()
Me.Refresh
End Sub
hth.

 

[wizz_darlo]

Thankyou for your reply,
However as I mentioned above, I have no VB skills so as such do not know where to enter this slice of code!!

If you could advise on this it would be a great help.

Many Thanks

 

[quest4]

Right mouse the control you want to modify, in this case the form, which you select the upper left hand corner, and select properties. Select the Events tab, then locate the event where you want to add your code, in this case, OnActivate, then when you move the mouse across the textbox next to OnActivate just inside the margin area, thre dots should appear, "..." left mouse them and a pop-up menu will appear. Select code builder, then the vb editor will open in the event then copy and paste this into the procedure: Me.Refresh
It should like exactly like what I copied above. Then close and save. Also try reading up some of this in Access help, try something like property and then get more specific help. hth.