Is this what you require:
Is this what you require:
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Many thanks Bob! I'm being a bit dim, but I can't see what you did! Can you talk me through it please?
Very simple, really.
Right clicked the textbox
Clicked Cut
Clicked the second tab
Right clicked and pasted
Then just aligned the controls and saved the changes 😀
That's what I thought you were going to do, but it looked the same when I checked! I'll have another look later.
I tried to do the same thing, but it wasn't working for me!
Thanks ssanfu! I'll have to wait until the morning now to check, but thanks for checking that for me. I'll get back to you tomorrow morning.
Steve
MANY years ago, when I was a lad, the phrase often used was, "My two pennyworth"..........But my memory is not as good as it once was
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Morning Steve and Bob (assuming it's morning for you too!),
I just uploaded my edited db. The only thing I'm not sure how to fix is the look up fields in the T-Payments table. I think I used a wizard for this initially. Could you possibly talk me through how to fix that please? Also, why is it considered bad practice to have a look up field in the table?
When I checked my main db, I must have spotted the dodgy relationship between the T_Engagements and the T_Payments, because it seemed to be correct there. I've changed that on the practice copy. Does it look ok now?
I also changed the field names to PlayerId. Thanks for that suggestion.
How's it looking so far?
Many thanks.
I've attached my db again. I must have done something funny! On the FrmMusicians form you set up for me Bob, when I search for musicians in the Find Musician box, it doesn't seem to work anymore. Do you know how I can fix it? Many thanks.
The "Find" combo box has the following line of code in its AfterUpdate event:
20 DoCmd.SearchForRecord , "", acFirst, "[PID] = " & Str(Nz(Screen.ActiveControl, 0))
PID was the Primary key of the table used for the form's data. You have changed that fields name to PlayerID so the line of code needs to be changed to:
20 DoCmd.SearchForRecord , "", acFirst, "[PlayerID] = " & Str(Nz(Screen.ActiveControl, 0))
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
I see! Many thanks Bob. I'll see if I can change the code now.
Edit...I changed the code, but it doesn't work just yet. Is there something else I also need to do? Thanks.
Not that I'm aware of. It worked for me. Perhaps you could post your latest version with the code changes that you made for me take a look at.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
That's strange! Here's my edited version.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
I think my db has a mind of it's own! Before, once I selected the player, I'd click on tab or return, and it would bring up the relevant player. I'll keep trying to solve it. Thanks for your help.