A simple "find record" request... I think

[cvansickle]

Good Morning...

I have a very simple form I created to allow a few of my warehouse people to clock in / out each day.

I am still learning, so it is very basic.

The trouble I am having.. Is when the employee clicks the "Clock In" Button I have it populate a text field (datename) with a unique text (date & name = "2/13/2019John Doe")

Then when they click on the "Clock Out" button I want to to search records and find the unique text that is in datename field. and enter the clock out time in that same record

I current have:

DoCmd.FindRecord "2/13/2019John Doe", , True, , True -

and it works perfectly. But I want it to search the text in datename? I have tried several ways to enter it. But can not get it to search for the text in the textbox?



Hopefully that make sense?

Any ideas??

Thanks

[ranman256]

if you have a form showing all records (continuous form)
right click on text box,
CONTAINS,
enter text: JOHN

the list will filter.

[cvansickle]

Not sure I understand..

when an employee hit the clock in button, it will put the unique text in datename field -

[datename] = [Today] & [Sorter_Name]

then when they hit the clock out button on the same form, I want it to "find the record" based on test string in datename field.

I am able to get it to work if I use the text in datename field.

DoCmd.FindRecord "2/13/2019John Brown", , True, , True. But I am not sure how to get it to look at the text string in the text field.

I have tried things like - DoCmd.FindRecord [datename], , True, , True OR DoCmd.FindRecord me.datename, , True, , True

However, those do not work

[Gicu]

What happens if you try DoCmd.FindRecord Me.datename?

Cheers,
Vlad

[cvansickle]

Thanks for everyones help!!

I think I figured out where I was going wrong.

when I hit "Clock Out" button, I was starting with a new record, so my field was null.

I added a line before the findrecord

[Name2] = Date & Forms!TimeClock!Combo23.Column(1)
DoCmd.FindRecord Me.Name2, , True, , True

Then the name2 field had the data I was looking for.. And WAA LAAAA



Thanks again for the time and the help!!