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

List Box to Move to record

P: n/a
Friends, I have created a form named FRMNEWCLIENTS whose record source
is a table named NEWCLIENTS. This table has a field named FILENUMBER.
I have added on the form a combobox using the third option "find a
record based on my form based on the value I selected in my combobox".
This is great since it allows me to open the form and use the combo to
move to a selected records. My form has also two other fields named
FNAME and LNAME.

My database has also another table, named OLDCLIENTS which has also
fields named, FILE NUMBER, FNAME and LNAME.

It may happen sometimes that I will need to copy some record from the
table OLDCLIENTS to the table NEWCLIENTS and was now wondering if it
is possible to add another combobox to my FRMNEWCLIENTS with a record
source to TBLOLDCLIENTS (which will display the three fields
FILENUMBER, FNAME and LNAME) and that on the onChange Event will copy
the selected record to the three fields (FILENUMBER, FNAME and LNAME)
on my FRMNEWCLIENTS.

Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Paolo,

You would be better off with just one table and a field to identify
whether this is a new or old client. I use a checkbox ticked if old
or unticked if new. Your forms based on new clients would have query
as your recordsource where FIELDOLDNEW has "No" as its criteria. In
other words only the new clients would be available to view etc.

Conversely you could have another form for old clients with the query
based on criteria "Yes" for FIELDOLDNEW. You should have the field
available on both forms so you can mark a client according to whether
they are new or old.

David Mitchell

jp***@tin.it (Paolo) wrote in message news:<9f**************************@posting.google. com>...
Friends, I have created a form named FRMNEWCLIENTS whose record source
is a table named NEWCLIENTS. This table has a field named FILENUMBER.
I have added on the form a combobox using the third option "find a
record based on my form based on the value I selected in my combobox".
This is great since it allows me to open the form and use the combo to
move to a selected records. My form has also two other fields named
FNAME and LNAME.

My database has also another table, named OLDCLIENTS which has also
fields named, FILE NUMBER, FNAME and LNAME.

It may happen sometimes that I will need to copy some record from the
table OLDCLIENTS to the table NEWCLIENTS and was now wondering if it
is possible to add another combobox to my FRMNEWCLIENTS with a record
source to TBLOLDCLIENTS (which will display the three fields
FILENUMBER, FNAME and LNAME) and that on the onChange Event will copy
the selected record to the three fields (FILENUMBER, FNAME and LNAME)
on my FRMNEWCLIENTS.

Thanks.

Nov 12 '05 #2

P: n/a
jp***@tin.it (Paolo) wrote in message news:<9f**************************@posting.google. com>...
Friends, I have created a form named FRMNEWCLIENTS whose record source
is a table named NEWCLIENTS. This table has a field named FILENUMBER.
I have added on the form a combobox using the third option "find a
record based on my form based on the value I selected in my combobox".
This is great since it allows me to open the form and use the combo to
move to a selected records. My form has also two other fields named
FNAME and LNAME.

My database has also another table, named OLDCLIENTS which has also
fields named, FILE NUMBER, FNAME and LNAME.

It may happen sometimes that I will need to copy some record from the
table OLDCLIENTS to the table NEWCLIENTS and was now wondering if it
is possible to add another combobox to my FRMNEWCLIENTS with a record
source to TBLOLDCLIENTS (which will display the three fields
FILENUMBER, FNAME and LNAME) and that on the onChange Event will copy
the selected record to the three fields (FILENUMBER, FNAME and LNAME)
on my FRMNEWCLIENTS.

Thanks.


Just add a Yes/No field to your table and then you can show/hide
enable/disable it whenever you want... and keep the data all in the
same table. Otherwise you will have to do ugly stuff to get it back
together... well,

SELECT Field1, Field2,...
FROM TableA
UNION ALL
SELECT Field1, Field2,...
FROM TableB
ORDER BY Field1, Field2,...

possible, but not always ideal. If you add filters to your form, you
can hide any records you want... or just change the rowsource...
(sorry for the typos... typing with my eyes closed...)
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.