Populate a table with qulifing fields froma another table

[JattilaB]

I would like to populate a table with date from another table but the only
data I want to populate with is ones that has a cretin value for one of its
fields

dose this make sense? I would like to do this by a module or by clicking a
cmd.button.


any help would be appreciated

 

[John Nurick]

Hi Jattila,

You can normally do this with an Append query, with an appropriate
criterion on the field in question.

Once the query is created you can use a command button to run it. One of
the options in the Command Button Wizard, under Miscellaneous, is "Run
Query".