dropdown doing an append query

[AccessNewbie2007]

Hello, I have 2 tables with exactly the same structure (one full of data and the second empty) and 2 forms also the same, the only difference is that the 2nd has a dropdown with values from a field of Table1 (Full Name). I am using an append query to move record from Table1 to table2 based on the dropdown selection of FullName and they are stored correctly.

When I choose a name for example Johny Dee; all the records of this row are moved to the new table successfuly but I want also to display them in the form immediately; what I am getting is the 1st record only and not the choosen one. pls advice

 

[jal]

When I choose a name for example Johny Dee; all the records of this row are moved to the new table successfuly but I want also to display them in the form immediately; what I am getting is the 1st record only and not the choosen one. pls advice

"All the records of this row." Huh? I don't understand. I thought that one record is one row. Normally a row doesn't have "records" nor vice versa.

Secondly, what do you mean, " When I choose a name for example Johny Dee" - sounds to me like you are filtering to only return one record, in which case the drop down should only have one record.

You may want to clarify your question.

 

[AccessNewbie2007]

you are right one record is one row. just to clarify further:

Table1:
ID, FullName, Address, Mobile, Desc, Note1, Note2

Table2 (Same fields):
ID, FullName, Address, Mobile, Desc, Note1, Note2

Form1: a form for Table1 entries

Form2: form with Table2 entries and 1 dropdown with FullName Values from Table1

When I select the dropdown of Form2, I am launching an append query to copy values from Table1 to Table2 based on the FullName Criteria and it is working just fine. what is not working, is the fact that I need also to show the record in the form after the append. is it clear now?

 

[stopher]

Hello, I have 2 tables with exactly the same structure (one full of data and the second empty) and 2 forms also the same, the only difference is that the 2nd has a dropdown with values from a field of Table1 (Full Name). I am using an append query to move record from Table1 to table2 based on the dropdown selection of FullName and they are stored correctly.

Why are you doing this? Holding identical data in more than one table is bad practice.

It sounds like you are wanting to filter data in a form based on a selection. In which case make the form based on your table and just change the forms filter based on what the user selects in the dropdrop.

Chris

 

[jal]

I tried to accomplish this. I display table2 in two different ways, first in a listbox, and secondly in a subform. In each case I display all the values of table2, not just the newly inserted value. Most of it was accomplished using VBA code, with a little help from the wizards. Virtually no use of the designer.

 

[jal]

I am new to subforms. It just occurred to me that one danger of the subform is that if the user changes the data, it will update the table. I think the solution is to go into the Designer and mark all the textboxes as "Locked", or mark the subform false for "AllowEdit", "AllowDelete", and "AllowInsert".

 

[AccessNewbie2007]

I am just selecting few records to be kept separately.

concerning the filter I tried to make a filter but it is not working properly