AccessDiscussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
Hi All
I have a sub form with an auto Number for call id. I need when this number is generated to update the main form caption with this number.
I have made several attempts myself to no avail
Suppose the textbox on the subform that has the Call ID is called txtCallID and the label in the main form is called lblTitle, then put something like this on the subform's On Current event and txtCallID's After Update event.
Me.Parent.Form.lblTitle.Caption = "Record for Call ID No. " & Me.txtCallID
Note that autonumbers are usually not something you show users. Those are more for the computer to keep track of records.
__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division
Updating main Form From Sub Form
Linear Mode
