By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,009 Members | 2,821 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,009 IT Pros & Developers. It's quick & easy.

Refresh data in a continous form

P: 77
Hi,

I have a continous form that displays Name and Address of Suppliers.
In the form there is a combo box for 'Active Address' and 10 other text boxes. All the fields coem from one table, "Primary Suppliers".
The combobox is for 'Active Address' with values 'Yes' and 'No'.Control source of the form is,
Select * from PrimarySuppliers where [ActiveSupplier]="Yes". I want the form to display only the Suppliers who has 'Active address' = "Yes".If user selects "No" in the combobox for a supplier I want the form to refresh and not show that particular supplier record in the continous form.

Please treat this as urgent and help me solve this.

Thanks
Sep 11 '08 #1
Share this Question
Share on Google+
5 Replies


missinglinq
Expert 2.5K+
P: 3,532
You need Me.Requery not Refresh. Place it in the AfterUpdate event of the combobox. But why in the world would you use a combobox for a simple Yes/No answer, instead of a checkbox?

Linq ;0)>
Sep 11 '08 #2

NeoPa
Expert Mod 15k+
P: 31,492
Are [Active Address] and [ActiveSupplier] two separate fields in the table. If so then a better explanation is called for. If not, then such carelessnes will waste time.

Either way, you don't ask the question in a way likely to allow speedy resolution.

PS. With full and clear information this is quickly and easily answered I'm sure.
Sep 11 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
Good catch, Ade! I missed what I assume is a typo, but, of course, doesn't have to be!

Linq ;0)>
Sep 12 '08 #4

P: 77
Hi,

Thanks for the replies. Sorry if I confused you, ActiveAddress and ActiveSupplier is the same field.

Thanks
Sep 12 '08 #5

NeoPa
Expert Mod 15k+
P: 31,492
You have a single field with two names! Are you sure?

Perhaps you could provide some meta-data info to help clarify this situation as I'm surely confused.

This will work much better if you can post the meta-data (info about the layout / structure) of the table in the same way as I use in my example. Click on the Reply button and you will have access to all the codes I've used. PK & FK stand for Primary Key & Foreign Key respectively. Please don't use any TABs in your formatted layout as this will not display correctly - Spaces only for layout.
Table Name=[tblStudent]
Expand|Select|Wrap|Line Numbers
  1. Field           Type        IndexInfo
  2. StudentID       AutoNumber  PK
  3. Family          String      FK
  4. SName           String
  5. University      String      FK
  6. Mark            Numeric
  7. LastAttendance  Date/Time
Sep 12 '08 #6

Post your reply

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