Update table based on bound text box (1 Viewer)

[inkbird01]

Hi, I have a form that populates information from tbl_home. The bound text box on the form is txt_ID

How do I update column tbl_home.Project where form.txt_ID = tbl_home.ProjectID?

 

[theDBguy]

Hi. Welcome to AWF!

Not sure I understand your question; but if the form is bound to the same table you want to update, then just do it on the form.

 

[inkbird01]

Hi. Welcome to AWF!

Not sure I understand your question; but if the form is bound to the same table you want to update, then just do it on the form.

Thanks! I want to update records in the tbl_home table where the text box parameter = tbl.home.projectID

 

[theDBguy]

Thanks! I want to update records in the tbl_home table where the text box parameter = tbl.home.projectID

Sorry, still don't understand the question. Are you able to post some screenshots?

 

[MajP]

Post your database or provide a well explained issue. Put some effort into asking a question if you expect anyone to bother putting in effort to answer it.

 

[inkbird01]

My append query is

UPDATE tbl_home SET tbl_home.IsActive = "FALSE"
WHERE (((tbl_home.ProjectID)=[Forms]![frm_ProjectDetails]![txt_projectID]));

But I get the "enter parameter dialogue box"
The form text box is bound, is this the issue?

 

[inkbird01]

see

Post your database or provide a well explained issue. Put some effort into asking a question if you expect anyone to bother putting in effort to answer it.

See response

 

[MajP]

maybe.

 

[Gasman]

My append query is

UPDATE tbl_home SET tbl_home.IsActive = "FALSE"
WHERE (((tbl_home.ProjectID)=[Forms]![frm_ProjectDetails]![txt_projectID]));

But I get the "enter parameter dialogue box"
The form text box is bound, is this the issue?

And the parameter is?
If IsActive is Boolean (which is would be in any of my DBs) then you just use False, without any quotes, which just makes a string.

 

[Pat Hartman]

UPDATE tbl_home SET tbl_home.IsActive = False
WHERE (((tbl_home.ProjectID)=[Forms]![frm_ProjectDetails]![txt_projectID]));

True and False are NOT strings. They are boolean values 1 and 0 although, Access uses -1 and 0.

Also, we have no idea what the context is or why you are trying to update a second table from I presume a form. Logically, this is probably wrong.

We also have no idea how/where you are running the query so the solution I suggested may not help at all.