' Find the appropriate record and set the form's bookmark 'Make reference to the form and it's underlying recordset Got it? here we go:ġ) frmMain should include field RecNo, among whatever others you want to include.Ģ) frmCont should also include RecNo, along with whatever others you want to include.Ĥ) Go to View > Form Header/Footer and make sure this is turned on.ĥ) In the header or footer of frmCont, create a button.Ħ) In the button's On Click event, paste the following code:īlnState = SysCmd(acSysCmdGetObjectState, acForm, "frmMain") frmMain is the "detail form" and frmCont is the continuous form from which we select records to display on frmMain. And while it may seem useless to even DO what I am trying to do, the old database program that I am converting to Access does this, and they want it 'just like the old one'.Īnd yes, if you help me figure this out, you CAN be my latex salesman! I still need the 'detail' form to be able to flip through all the records when this is done, not be filtered down to only the one selected on the c.f.Ĭlear as mud, right? This doesn't SEEM like it should be such a hard thing to do, but it is really kicking my butt. So really, this is simply another way of navigating through the record set by selecting the record you want to go to from a list of all of them. BUT, I need the entire recordset available still.just change the position to the one selected on the c.f. to close, and the original 'detail' form (from where we started) to be showing the record selected on the c.f.
and the Go to button is clicked, I need the c.f.
#Access find record button code#
I am assuming that I could (if it does what I need) put your code in the On_Click for that button, instead of on a field, right?Īnyway, when a record is selected on the c.f. hereafter) stays open in the background. It does not close when the continuous form (c.f. The main 'detail' form has a 'View' button on it which opens the continuous form with all the records. This is an Autonumber field, and is simply used for linking records and for navigational stuff like this. I'll add a bit more detail to my original info:įirst, I do have a unique field in the table called RecNo. But even if it did, I don't think it's going to do what I need it to do. I tried what you suggested and it doesn't work, probably due to my poor coding.
0 kommentar(er)
