Search results

I am getting the syntax wrong. Here's my dlookup =dlookup(field,table,where clause) =dlookup([Score],"Score",where Score.ChkInID = Form.Game2.ChkInID and Score.GameID = 1) =dlookup([Score],"Score","ChkInID = ' " & Forms![Game2].[ChkInID] & " ' and [GameID] = ' " 1) I've googled and none...

I am designing a bowling database for our summer league (my brother's brainstorm). I have a table Score that has the following fields: ScoreID (AutoNumber) ChkInID (FK - Number) GameID (FK - Number) LaneID (FK - Text) Score (Number) So, for each bowler and game, there will be 1 entry into...

Thank you so much! I appreciate your time and that you built a quick database to show me how it works. BTW, I did change my GameID from text to a number. Robecca

My check-in form is bound to a CheckInBowler table. This table has the ChkInID which is an autonumber, BowlerID, WkDate, PositionID and LaneID. On my check-in form, I have the BowlerID field as a combo box, showing the bowler name. Once the bowler is chosen, the ChkInID is assigned. I do...

I hope I explain this well. I am designing a database for a summer bowling league. This league's teams change weekly based on a blind draw. So I check in each bowler each week. I have a table Score to capture the games bowled. This table has a Primary Key ScoreID (auto numbered) and it has a...

Thank you JHB, that was exactly it. I'd been trying it on the tab control but chaning to the form worked perfectly!

Hello I’m working on a bowling database … I built a form (BowlerCheckIn) that has 3 tabs – “Check In”, “Assign Teams”, “High Pots” “Assign Teams” tab has a multiple items form “AssigningTeam” on it and this form is based on the query “AssignTeam”. After checking in the bowlers on the “Check...

Hi, my name is Robecca and I am new to forums. I'm in the west coast of the USA. I have been using Access since 1994 but have never gotten into complex forms or VBA until now. Looking forward to learning a lot.