Value put in textbox for field in same table as combo box selection

[david.paton]

I found an issue. I can't get the work location ID working in frmCrisisSupportWorkers, and I didn't know if I really needed it.

 

[GinaWhipp]

I keep getting distracted... did you want me to look at that Form?

 

[david.paton]

That form and the search form and I wasn't sure if I needed a work location ID in my table tblCrisisSupportWorkers.

Thanks

 

[GinaWhipp]

What do you mean you can't get Location working? I can select a Location. I guess I don't understand how you are going to use these Forms to give you a proper evaluation. Perhaps you could explain?

 

[david.paton]

I meant, location appears to work fine. In the table, I noticed a WorkLocationID field and I wasn't sure if it was needed as I wasn't really using it but I wondered if I should be using it somewhere.

Only thing is that I can't make a relationship from it to the location table as there is already a relationship between the two tables so I think I would need a separate table but that would create redundancy issues as I can the TC location from the main location table. All I need is to link it with the combo box wizard.

So, it is working with using the combo box wizard to lookup the location table for the home location and the TC location. It stores this in cLocationID and TCLocationID.

Hope this makes sense

 

[GinaWhipp]

Then remove it... you don't have to keep it there, I only thought you wanted a Location of residence and a seperate Work Location.

 

[david.paton]

Thanks for bringing that to my attention. I asked my manager and she does want it drawing from separate tables, so I will use that. I will just need to make another table.

 

[GinaWhipp]

Oh okay, good thing you asked!

 

[david.paton]

Does my search form appear to work alright? Just thought someone else should look at it through a fresh of set eyes, in other words, not me. Something may be spotted that I missed.

 

[GinaWhipp]

I'm not sure *how* it's suppose to work, what should I enter?

 

[david.paton]

Guess it is a bit hard to test it if you don't know how to test it or how it should work. Maybe I will continue testing and let you know if I have problem

 

[david.paton]

I have made a button on my form to go to the next tab or make a new tab but how do I get the focus to switch to the TC number field once I select that button?

 

[GinaWhipp]

Umm, which Form? And what is the code you used?

 

[david.paton]

I put it on frmCrisisSupportWorkers. I wanted to select it to go to the next or a new record then the focus to go up to the TC number so you don't need to take your hands of the keyboard.

I can use the features of the button to make it go to a new record but I don't know how to set the focus to the cTCID field.

Should I also rename this field to txtTCID as cTCID was just the default name and I never changed it?

 

[david.paton]

Here is the database

 

[david.paton]

I think I might know how to do it, I just don't know the vba code to select the next record. I have renamed the text field to txtTCID so I could just use the code txtTCID.setfocus I think.

 

[GinaWhipp]

Okay, looking now...

 

[GinaWhipp]

Only problem is the State field will now error because it's using a DLookup.

 

[david.paton]

That's great Gina, thanks for that. How did you do it?

 

[GinaWhipp]

I just added a GoToControl in your Embedded Macro, have a look and you will see it in there.