Recent content by FameAsser

Hi all So I have two queries...both feeding from linked tables. They now both have the exact same columns in them. One is a table of "Placeholder Predictions"...so predictions all players have made prior to the game. The second table has all the "New Predictions"...all predictions made by all...

CJ - You are an absolute Superstar! I knew I needed to Subquery somewhere along the line but couldn't get my head around it. Thank you again

So I have searched everywhere and can find half of the answer but not the other half. :banghead: I have a table of predictions. For MatchID #1, PlayerID 56 predicted twice, so I need to take the latest prediction from them, but I also need everyone else's predictions. I have attached how it...

I am very new to all this so it's a massive learning curve for me. Is it an easy-ish fix or a bit of a nightmare?

No problem...here goes : f_Main has nothing specific happening to it. It's just holding the subforms and the buttons as on f_main image attached. img f_result popup is the opened popup. When I select the dropdown to be the last match (the dundee game) it populates with all the info as so ...

Apologies...I feel like it's almost there but eluding me. I am now using this in the code : Forms!f_main!subfrmFront.Form.Requery I tried refresh too and it didn't work either. The Popup form just closes and nothing changes in the subform on the f_Main. The subformcontrolname is subfrmfront...

OK - I am in the close event : Private Sub Form_Close() Forms!f_main!f_Front.Form.Requery End Sub I have tried both requery and refresh I keep getting an error saying : f_main - the Main form I am on which contains SubForm 'subfrmFront' subfrmFront - the subform on f_main which is tied...

Where would they go? In the sub for closing the Popup?

Ah right yeah...it's making changes to the current record

f_front (which is the source object of the subform), opens a recordset to qryLastMatch which just pulls all the previous match information through from t_fixtures The popup opens a recordset to t_fixtures directly. In the Popup, there's a dropdown which allows me to choose any previous matches...

Hi I have my main form which is f_main. On there is a Subform called subfrmFront and that has a source object of the form f_front A button on f_main opens up a popup. In this popup, the fields I am updating all relate to the same records that are being displayed in the subform. Everything...

Wow! Thank you for spotting that! It is working now............haha...apologies for time wasting

Hi guys. I am driving myself insane trying to write this and could really do with help. Basic outline is that players predict the attendance of a football game. We award 1 point if they guess within 500 of the attendance, 2 points if within 250, 3 points if within 100, 4 points if within 50...