Solved Setfocus to newly added record in subform

[Rene vK]

I am using a separate, unreferenced, form to input a new record to a client-table. This extra form has a check-sequence before it will add the new record. Maybe it is a bit more work but the user can't add an empty record to the database.
Sorry for the dutch example in the attachment

 

[Deleted member 147267]

Your problem hasn't been clearly stated. Either it is that a user cannot add a new record as you've written, or it is that you can't set the focus to a field in a new added record as per your thread title.??

 

[Rene vK]

Your problem hasn't been clearly stated. Either it is that a user cannot add a new record as you've written, or it is that you can't set the focus to a field in a new added record as per your thread title.??

No Micron, I was just showing the solution(in another post) I use to inserting a new record donkey proof. (in another post)
In this application I struggled with the clients knowledge of IT. The choice of her client is via a combo, showing personal info. Sometimes she needs to add info to or edit a record, I fix that via a "edit" button that toggles the AllowEdit. With a popup I make sure she inserts a new client in a controled manner. I know this is not the best Access-way but it works flawlessly.

 

[Deleted member 147267]

Hmm, I would think that you'd just post your solution in the other thread?
In the least, state here that this is a solution and include a link to your other thread? You should probably be able to edit this one if you care to do that.

 

[Rene vK]

Hmm, I would think that you'd just post your solution in the other thread?
In the least, state here that this is a solution and include a link to your other thread? You should probably be able to edit this one if you care to do that.

My post was moved out of that thread by Cheekybudda.

 

[cheekybuddha]

My post was moved out of that thread by Cheekybudda.

???

Not me! I don't have such privileges here!

 

[Rene vK]

OOPS, sorry, splinter in the eye!!!
the message I got was :
Your post in the thread Setfocus to newly added record in subform was moved to Setfocus to newly added record in subform. Reason: I moved your question to a new thread where it will get more attention.
After that message was one that mentioned Cheekybuddha answered in the thread my post was moved out of.

My appologies

 

[Deleted member 147267]

Just seems bizarre to move a solution to a thread into a new thread for pretty much any reason, but it is BC (before coffee) so maybe that's why.

 

[cheekybuddha]