Function to create table

[moremon]

Hi all,
I was successful in creating a table with three fields from within a function by using the "CreatetableDef". My problem is, how do I assign values to the three fields from within the same function?


Thanks

 

[JoeMiller]

You can use DoCmd.RunSQL to run a SQL statement such as an Append query or an Update query to add data to your table after it's been created. Don't know the SQL statement you need? Create a query that does what you want in the normal query designer, click View-->SQL View and copy paste the statement that comes up into your code.

HTH Joe Miller
joe.miller@flotech.net