Mark Forums Read

Update main form control from subform

Go Back

comp.databases.theory comp.databases.theory

Reply

#1

Old

Joe

Posts: n/a

Update main form control from subform - 06-30-2008 , 12:45 AM

I have an Access database with two tables "Main" and "Rafflenumbers", also
a main form (for names etc) and a subform (for numbers assigned). I put an
unbound control on the Main form which I want to have updated with the last
number added to the control on the subform. I used this controlsource
"=Max(subform table!subform control)" in the unbound control which works
when the main form is loaded but does not update when I add a new record.
How can I have it update whenever I add a new record?

Reply With Quote

#2

Old

Philipp Post

Posts: n/a

Re: Update main form control from subform - 06-30-2008 , 04:45 AM

Quote:

How can I have it update whenever I add a new record?

Try the SomeNumber_AfterUpdate() field event in the subform to
transfer the data into the Me.Parent!SomeNumber field. Also the MS
Access forum might be a better place for help on this.

brgds

Philipp Post

Reply With Quote

#3

Old

Philipp Post

Posts: n/a

Re: Update main form control from subform - 06-30-2008 , 04:45 AM

Quote:

How can I have it update whenever I add a new record?

Try the SomeNumber_AfterUpdate() field event in the subform to
transfer the data into the Me.Parent!SomeNumber field. Also the MS
Access forum might be a better place for help on this.

brgds

Philipp Post

Reply With Quote

#4

Old

Philipp Post

Posts: n/a

Re: Update main form control from subform - 06-30-2008 , 04:45 AM

Quote:

How can I have it update whenever I add a new record?

Try the SomeNumber_AfterUpdate() field event in the subform to
transfer the data into the Me.Parent!SomeNumber field. Also the MS
Access forum might be a better place for help on this.

brgds

Philipp Post

Reply With Quote

#5

Old

Philipp Post

Posts: n/a

Re: Update main form control from subform - 06-30-2008 , 04:45 AM

Quote:

How can I have it update whenever I add a new record?

Try the SomeNumber_AfterUpdate() field event in the subform to
transfer the data into the Me.Parent!SomeNumber field. Also the MS
Access forum might be a better place for help on this.

brgds

Philipp Post

Reply With Quote

#6

Old

Philipp Post

Posts: n/a

Re: Update main form control from subform - 06-30-2008 , 04:45 AM

Quote:

How can I have it update whenever I add a new record?

Try the SomeNumber_AfterUpdate() field event in the subform to
transfer the data into the Me.Parent!SomeNumber field. Also the MS
Access forum might be a better place for help on this.

brgds

Philipp Post

Reply With Quote

#7

Old

Philipp Post

Posts: n/a

Re: Update main form control from subform - 06-30-2008 , 04:45 AM

Quote:

How can I have it update whenever I add a new record?

Try the SomeNumber_AfterUpdate() field event in the subform to
transfer the data into the Me.Parent!SomeNumber field. Also the MS
Access forum might be a better place for help on this.

brgds

Philipp Post

Reply With Quote

#8

Old

Philipp Post

Posts: n/a

Re: Update main form control from subform - 06-30-2008 , 04:45 AM

Quote:

How can I have it update whenever I add a new record?

Try the SomeNumber_AfterUpdate() field event in the subform to
transfer the data into the Me.Parent!SomeNumber field. Also the MS
Access forum might be a better place for help on this.

brgds

Philipp Post

Reply With Quote

#9

Old

Philipp Post

Posts: n/a

Re: Update main form control from subform - 06-30-2008 , 04:45 AM

Quote:

How can I have it update whenever I add a new record?

Try the SomeNumber_AfterUpdate() field event in the subform to
transfer the data into the Me.Parent!SomeNumber field. Also the MS
Access forum might be a better place for help on this.

brgds

Philipp Post

Reply With Quote

#10

Old

Philipp Post

Posts: n/a

Re: Update main form control from subform - 06-30-2008 , 04:45 AM

Quote:

How can I have it update whenever I add a new record?

Try the SomeNumber_AfterUpdate() field event in the subform to
transfer the data into the Me.Parent!SomeNumber field. Also the MS
Access forum might be a better place for help on this.

brgds

Philipp Post

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.