access thread: Refresh Table After Getting Value Externally
Message #1 by "Hannu Turunen" <hannu.x.turunen@h...> on Mon, 15 Oct 2001 09:34:48 +0300
|
|
Hi
I have a Form wich has a Combo and a Subform in which I try to show
sellection I made in combo. On exit Combo I put the value to table linked
to that Subform. How I refresh the table so that selection done will
appears at once after sellection?
hannu.x.turunen@h...
Message #2 by "Hannu Turunen" <hannu.x.turunen@h...> on Mon, 15 Oct 2001 08:13:03
|
|
Hi
I have a Form wich has a Combo and a Subform in which I try to show
sellection I made in combo. On exit Combo I put the value to table linked
to that Subform. How I refresh the table so that selection done will
appears at once after sellection?
Hannu.Turunen
Message #3 by "Sanna Korpela" <sanna.m.korpela@l...> on Tue, 16 Oct 2001 12:36:55
|
|
No terve Hannu!
I tried to make that work but after many experiments I just made a button
in the mainform to refresh the whole form. For some reason Combo didn't
accept Form.refresh or requery. If you find a way to make it work, it
would be nice to hear it.
sanna.m.korpela@l...
Message #4 by "Hannu Turunen" <hannu.x.turunen@h...> on Tue, 16 Oct 2001 15:10:40 +0300
|
|
Hei hei Sanna
Thank you for your advice. Think to do same way but for my delectation I
found that requery supports a control on the active object so I try this:
Private Sub ComboBox1_Exit(Cancel As Integer)
Dim vaKoe As Variant
vaKoe = ComboBox1.Text 'to get variable from ComboBox
' vaKoe will set (with concatenation) to Sql
statement to doing insert
'SQL statement with INSET INTO command that insert VALUES to database
DoCmd.Requery "ListOfValues"
'"ListOfValues" is connected to the database
'"ListOfValues" is listbox i.e active object
End Sub
You may perhaps try to this one.
-----Original Message-----
From: Sanna Korpela [mailto:sanna.m.korpela@l...]
Sent: Tuesday, October 16, 2001 12:37 PM
To: Access
Subject: [access] Re: Refresh Table After Getting Value Externally
No terve Hannu!
I tried to make that work but after many experiments I just made a button
in the mainform to refresh the whole form. For some reason Combo didn't
accept Form.refresh or requery. If you find a way to make it work, it
would be nice to hear it.
sanna.m.korpela@l...
Message #5 by John Fejsa <John.Fejsa@h...> on Wed, 17 Oct 2001 08:13:12 +1000
|
|
Hi Sanna,
Make sure report detail section is set to visible and not set to invisible
by accident.
1) Right click details section
2) Selsect Properties
3) Click Format
4) Make sure that Visible option is set to Yes
_____________________________________
John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10
WALLSEND NSW 2287
Phone: (02) 49246 336 Fax: (02) 49246 209
|
View Cart
