list items edit form properties to open to specific record

[d9pierce1]

Hello All.
I am trying to figure out this "list items edit form" Property. I have a form (City) and a form (State), A combo box in Form (City) that is called State, Created with wizard [StateID];[State] and in the property I have set the "list items edit form" to form (State). Works however it goes to first record in State and I want it to go to the current record I want to edit in form City. I have tried pacing the "Forms!FormName!FieldName" to various places within the form (State) to try to bring the selected edit over with no success.

Basic question is how do I use this property to edit the selected record in the form it opens? I dont want to sort through all the records to find the one I want to edit.


Thank you,
Dave

[orange]

I suggest you post a copy of your database in zip format.

[d9pierce1]

Here it is, thanks

[orange]

I'm not sure I am following what you are trying to do with
a) the database forms both state and city,
b) the list items edit

If you are creating a table of States, and a table of Cities with a State(s), what exactly is your process?
Access will save a record when you move off that record, so an explicit "save" is not required.
When I tested your form I get a message that "Undo" is not available?
I have used the list items edit when adding a new record to a list. See this thread post 49--51. There are references to details in those posts.

[d9pierce1]

Tbl_State Holds only state info, Tbl_City holds city and zip associated with state.
The Property I am referring to is when on Frm_City and I use the "list items edit form" property, it gives a little icon to edit when I drop down on the combo box. You click the edit Icon and it takes you to the Frm_State to edit the record. Well, It takes you to the first record on the Frm_State instead of the record you want to edit that is all ready in the combo box. This is a sample db just to get the controls correct before adding serious data and is part of a larger db I am working on. So, I am looking to see how if I hit the popup edit when clicking on the CboState in Frm_City, it will open the Frm_State to the specific record I want to edit, not just all records starting with the first. If I have 30,0000 records this command is useless for the purpose. Is there a way to get this info to the Frm_State?

Lets say!
Frm_City:
Selected Txt City = West Creek
Selected CboState = NJ
Selected TxtZip = 08092

I want to edit CboState so I click on the down arrow, a list presents with an icon under it to edit. If I hit edit icon, it takes me to Frm_State but to the first records of all records. Even though I have all ready specified a state to edit in the CboState. I dont want to edit all records, just that one! I hope this makes sense.
Thanks

[davegri]

d9Pierce1_davegri-v03.zip

I don't think it's going to work the way you want, but here's a workaround.
I modified the query to include the StateID from tbl_City (the FK), and made that field the controlsource for cboState in frm_CIty.
Created a rowsource for cboState on frm_City.
Created TempVar!tvStateID when cboState is double clicked in frm_City. The double click also opens frm_State with a filter to call up the proper state.

[d9pierce1]

Thank you, I thought that property was to easy to work good! Thank you