473,321 Members | 1,778 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Updaing list of names on the subform

I have a form called NewPatient for new patients entry. What i want is that, i need to update or completely refresh the MainForm and it will automatically display in subform1 for the list of patients currently admitted.

I try the requery and refresh upon MainForm_Active() but nothing happen. all i will do is that to press the F5 in order to refresh it completely.


-Thanks for helping-
Jul 6 '09 #1
6 1421
yea i did that but nothing happened. im using ms 2007 too.
Jul 6 '09 #2
Its not working still i dont know why.
Jul 6 '09 #3
mshmyob
904 Expert 512MB
I don't have enough info but I do not think that putting it in the Activate event will do what you want. You will need to put it somewhere else.

cheers,
Jul 6 '09 #4
@mshmyob
But how would i do it?
Jul 6 '09 #5
mshmyob
904 Expert 512MB
Again without more details from you, most often this type of thing would be done in the AfterUpdate event of the form or a control or in the AfterInsert event.

cheers,

@mjworks2009
Jul 7 '09 #6
I figure it out how to. i used the timer event

Private Sub Form_Timer()
If Me.Timer = 0 Then
Me.subform1.Requery
Else
Me.Timer = Me.Timer - 1
End If
End Sub

in this way the subform1 will refresh every second.

Thanks alot for the reply.
Jul 7 '09 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Darryl B | last post by:
I can not get anywhere on this project I'm tryin to do. I'm not expecting any major help with this but any would be appreciated. The assignment is attached. The problem I'm having is trying to set...
8
by: PeteCresswell | last post by:
I'm looking for some code that makes a list presented in a subform autoscroll in response to the user typing - like a combo box dropdown or a regular ListBox does. I.e. The user is looking at...
4
by: CSDunn | last post by:
Hello, I have a combo box (Combo7) that needs to call a function during the After Update event of the combo box. The function resides in an Access 2000 ADP Module called MMAnswerData_code. The...
3
by: Paul T. Rong | last post by:
I have a listbox (of product names) control on my form. I want to pass the selected item (a product name) to a subform, and the product unitprice should apear automatically next to the product name...
1
by: sparks | last post by:
I have a main table with teacher names and students I can put this in a subform and filter by teacher name so I have a list of her students in a sub form. the problem I have is this is created in...
2
by: Elainie | last post by:
I have a main form and a subform linked together, subform is filtered via the Surname field.. my users want to be able to click on the list of names within the subform and then bring that data into...
1
by: christianlott1 | last post by:
I want to provide users with an interface to create a custom merge (all in Access, not Word). User will put in a set of brackets ("<>") in a memo field and when they click the merge button it will...
5
by: gazgump | last post by:
I'm doing some practice questions and cant seem to work out these collection probelms think i need to use iterator or a while loop but cant seem to get them to work - dont really know how i'd go...
0
by: Gordon Padwick | last post by:
A form contains controls, one or more of which can be other forms. A form that contains another form is known as a main form. A form contained by a main form is known as a subform. A subform itself...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.