need help with a vb statement in access

[ArchMichael]

i need help with vb in access. i have table call main_tbl and another table called details_tbl.

main_tbl has the following fields
issueID, text, PK
PN, text
description, text
openby, text
opendate, date

details_tbl has the following fields. the details_tbl is use by other forms
id, text
PN, text
user, text
udate, date

the problem i am encountering is that when i do following script
db.Execute "INSERT INTO details_tbl SELECT main_tbl .IssueID,main_tbl.PN,main_tbl.OpenBy,main_tbl.Date Opened from main_tbl "
i get an error of "the insert into statement contain the following unknown field: openby....". i have feeling i know why it popup but how can i make this work properly without renaming openby field because it is use by other forms.

[janders468]

Based on what you are posting you are trying to insert the field OpenBy from the Main_tbl into the Details_tbl, however there is no corresponding OpenBy field in the Details_tbl. Don't include it in your select statement, only include the fields that will actually be appended in your select statement.

[ArchMichael]

thought so, thanks anyway

[janders468]

I may be inferring too much by your response, but this won't break anything in your other forms because you aren't changing the underlying table structure, it only affects the one query you are using so this shouldn't have an affect on anything else. Does that help?