Find data in main form

[deepaksharma]

This code used in combo box to find any data
DoCmd.SearchForRecord , "", acFirst, "[ID] = " & Str(Nz(Screen.ActiveControl, 0))



I want to use it in the after update event of the ID text box made in the form , for this what changes do i have to make in it coding. Note that I will use this in a simple "ID" text box that is directly connected to the table's "ID" control source and not in an unbound combo box.

[Bob Fitz]

This code used in combo box to find any data
DoCmd.SearchForRecord , "", acFirst, "[ID] = " & Str(Nz(Screen.ActiveControl, 0))

I want to use it in the after update event of the ID text box made in the form , for this what changes do i have to make in it coding. Note that I will use this in a simple "ID" text box that is directly connected to the table's "ID" control source and not in an unbound combo box.

IMHO that's not a good idea. I would stick to using an unbound combo to find a record. I don't see how you can use a bound control as a control to be used for the entry of data that you want to search for.

[deepaksharma]

You are right, but I have seen many data software programs that start with ID number (Bill number, Invoice number, Roll number, etc.) By entering the id number, as soon as the enter is hit, the data related to it comes on the form and they easily update the change, they do not use any other unbound box to find the record, then how do the programmers make it possible?

[deepaksharma]

IMHO that's not a good idea. I would stick to using an unbound combo to find a record. I don't see how you can use a bound control as a control to be used for the entry of data that you want to search for.

For example you see this demo program if I want I can do this coding in my program but my program has a sub form attached so coding of this form is not working in that form

https://drive.google.com/file/d/1Au9...w?usp=drivesdk

[Welshgasman]

You are right, but I have seen many data software programs that start with ID number (Bill number, Invoice number, Roll number, etc.) By entering the id number, as soon as the enter is hit, the data related to it comes on the form and they easily update the change, they do not use any other unbound box to find the record, then how do the programmers make it possible?

You would have to save the value and replace it, before the record is saved, located. Fraught with potential problems, more work to maintain. Experienced developers would not do it. That should tell the amateurs something?

You could overlay an unbound control over the bound control and show and hide it all the time perhaps.
Otherwise copy the code in that dB?

[deepaksharma]

You would have to save the value and replace it, before the record is saved, located. Fraught with potential problems, more work to maintain. Experienced developers would not do it. That should tell the amateurs something?

You could overlay an unbound control over the bound control and show and hide it all the time perhaps.
Otherwise copy the code in that dB?

How will this happen "You could overlay an unbound control over the bound control and show and hide it all the time perhaps."

[CJ_London]

Or just right click on the control to use the built in sort and filter functionality

[Bob Fitz]

You are right, but I have seen many data software programs that start with ID number (Bill number, Invoice number, Roll number, etc.) By entering the id number, as soon as the enter is hit, the data related to it comes on the form and they easily update the change, they do not use any other unbound box to find the record, then how do the programmers make it possible?

I have no idea. As I've already stated, I would not do it. I would use a combo in the forms header section. Tried, tested, works, been done a million times before. I suspect that the code required to achieve your goal is just not worth the headache. I see no benefit in pursuing it.

[Welshgasman]

You have a control exactly placed over the other control, same size etc.

I have never had to need to do it, so you might want to google how, or look on Youtube.

That DB that you linked to has bound fields, yet uses a recordset to update a record?

Copy that logic then.

[Bob Fitz]

......That DB that you linked to has bound fields, yet uses a recordset to update a record?

Copy that logic then.

Perhaps the OP doesn't like doing things the easy way

[deepaksharma]

You have a control exactly placed over the other control, same size etc.

I have never had to need to do it, so you might want to google how, or look on Youtube.

That DB that you linked to has bound fields, yet uses a recordset to update a record?

Copy that logic then.

yes this uses a recordset to update a record.

[deepaksharma]

[QUOTE=Bob Fitz;516084]I have no idea. As I've already stated, I would not do it. I would use a combo in the forms header section. Tried, tested, works, been done a million times before. I suspect that the code required to achieve your goal is just not worth the headache. I see no benefit in pursuing i

[deepaksharma]

Perhaps the OP doesn't like doing things the easy way

If you see my demo program once,

[Welshgasman]

If you see my demo program once,

One of the hardest thing I had to get my head around when I started with Access, was the idea of bound controls.
I had dabbled with Foxpro in the past and there you would Scatter Memvar to put in form and Gather Memvar to put back to the table.

[deepaksharma]

Perhaps the OP doesn't like doing things the easy way

Ok, I would like to apply your method. Please tell me whether I can create this find combo box only on the form header footer or in the form working area also and My second question is whether the combo box can be stopped from showing the list and if yes then how?