Clear form

P

pm4698

Registered User.
Local time
Today, 05:50
Joined
Jan 23, 2010
Messages
72
Hello there.

I have 3 combo boxes in a row that take values from table fields (name, surname and ID) and i have selected the choice continuous form.
So, i get all users (name, surname and ID).
I have a clear button, in which i have written at on click event:

me.comboboxname1.value = ""
me.comboboxname2.value = ""
me.comboboxname3.value = ""

When i push the button, i get only the first row of combo boxes (first record) cleared but the rest remain as before.

How can i clear the other combo boxes (records) from the form too?

THanks in advance
 
Sounds like you need to execute a query to clear the forms underlying table fields.
 
It is one form actually.
Consider one row with fields:

Name, Surname and ID but from the form properties i have selected the option:continuous form.

So i get at one form all the records(name, surname ID) as continuous records of the same form.

I cannot manage the names of the other rows 'cause they do not exist in the design mode
 
Can you post a screen shot? Unless I'm missing something you're best option is to do the query thing I suggested.
 
Here is an attachment.

The language is greek and i have written over the table field with red color.

This is at design mode.
When i turn it to projection mode i get all the records.
If for example i have 10 records at the table where i drag the fields, then i get all the 10 records as rows.
 

Attachments

  • test.png
    test.png
    6.8 KB · Views: 110
I can't imagine ever needing to do what you're suggesting but it seems you still need to do this with a query...
 
I know that i need i query, i just do not know how to write it, 'cause i cannot manage the other rows' fields cause they are multiplying depending on the records of the table
 
You make a query that returns the same set of records that you see in the form and then turn it into and update or delete query.

If you don't mind I am going to bail out of the thread as I am running out of patience...
 
You must log in or register to reply here.

Similar threads

B
Combo Box Search Issue
2
Replies
34
Views
1,001
MajP
MajP
D
Solved Clearing Recordset property value in Combobox
Replies
15
Views
446
DalynSoft
D
HavingDatabaseRelations
Solved Combo Box will only work if Access is not minimized
Replies
10
Views
256
Mike Krailo
Mike Krailo
R
Delete record in dependent cascading combo box
Replies
4
Views
169
RFreund
R
H
Solved Search across multiple fields
Replies
8
Views
631
Harry Paraskeva
H

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom