Simple update query / form question

  • Thread starter Thread starter wazza_c12
  • Start date Start date
W

wazza_c12

HI There

I have a little database project for my internship that is so close to
finished, I have one last hurdle before either my brain explodes or I
get it done.

I have a display form showing a record, it has an edit command button
that opens another form to the same record.

On this second editing form I have all the boxes unbound so that the
user can change what they want then hit an "update" button to do the
updating, or a cancel button if they desire.

I'm having problems getting this update query working properly (that
the update button calls)

I currently have

UPDATE Details SET Field1 = Forms!Edit_Record!Field1
WHERE ID = Forms!Edit_Record!ID

It's completely not working.

Am I using a subform? do I have to add that to the path? ie.
Forms!Display!Edit_Record!ID

ID (my primary key) is not actually on the form, but is still part of
the current record (I assume) how do I reffer to it? is that the
problem?

Thankyou for any help, I'm sure this is the most simple question
posted, I've just been sitting at the PC too long

Thanks in advance

Warwick
 
HI There

I have a little database project for my internship that is so close to
finished, I have one last hurdle before either my brain explodes or I
get it done.

I have a display form showing a record, it has an edit command button
that opens another form to the same record.

On this second editing form I have all the boxes unbound so that the
user can change what they want then hit an "update" button to do the
updating, or a cancel button if they desire.

I'm having problems getting this update query working properly (that
the update button calls)

I currently have

UPDATE Details SET Field1 = Forms!Edit_Record!Field1
WHERE ID = Forms!Edit_Record!ID
Click to expand...

You have this where? In a query? In VBA code?
It's completely not working.

Am I using a subform? do I have to add that to the path? ie.
Forms!Display!Edit_Record!ID

ID (my primary key) is not actually on the form, but is still part of
the current record (I assume)
Click to expand...

Why would you assume it's "in the record"? Unbound forms don't have a record.
Sort of the point of an unbound form actually. Unless you have some hidden
controls what you see is what you've got.

With your unbound form open type each the following into the immediate window
one at a time...

?Forms!Edit_Record!Field1 <Enter>

?Forms!Display!Edit_Record!ID <Enter>

Do they return a value? Are they what you expect?
 
UPDATE Details SET Field1 = Forms!Edit_Record!Field1
WHERE ID = Forms!Edit_Record!ID
Click to expand...


You have this where? In a query? In VBA code?

It is in a query called by a command button
It's completely not working.
Click to expand...
Am I using a subform? do I have to add that to the path? ie.
Forms!Display!Edit_Record!ID

ID (my primary key) is not actually on the form, but is still part of
the current record (I assume)
Click to expand...



Why would you assume it's "in the record"? Unbound forms don't have a
record.
Sort of the point of an unbound form actually. Unless you have some
hidden
controls what you see is what you've got.

Well I used a command button wizard to establish the link between the
first and second forms, the second form has a control source of my
details table and a filter set to whatever record ID I'm editing. .....
It is just that I chose not to bind my fields on that form, they are
populated by code when the command button is pressed on first form

With your unbound form open type each the following into the immediate
window
one at a time...


?Forms!Edit_Record!Field1 <Enter>


?Forms!Display!Edit_Record!ID <Enter>


Do they return a value? Are they what you expect?

No values

Hope that clears things up a little
Cheers
 
You have this where? In a query? In VBA code?

It is in a query called by a command button
Okay.

Why would you assume it's "in the record"? Unbound forms don't have a
record. Sort of the point of an unbound form actually. Unless you have some
hidden controls what you see is what you've got.

Well I used a command button wizard to establish the link between the
first and second forms, the second form has a control source of my
details table and a filter set to whatever record ID I'm editing.
..... It is just that I chose not to bind my fields on that form,
they are populated by code when the command button is pressed on
first form
Click to expand...

Okay so it is not an unbound form, but rather a bound form with some unbound
controls on it. That should work I suppose.
With your unbound form open type each the following into the immediate
window
one at a time...

?Forms!Edit_Record!Field1 <Enter>

?Forms!Display!Edit_Record!ID <Enter>

Do they return a value? Are they what you expect?

No values
Click to expand...

Had you opened the second form from the first and made an entry in the unbound
control Field1? If so then you should have gotten values returned when you
pressed enter. Either you are not referring to the form or field/control
correctly or there are no values there.

Actually looking again the second reference has too many bangs (!). It should
be...

Forms!FormName!FieldName
(two bangs)

Why do you have "Display" in there?
 
Rick said:
Actually looking again the second reference has too many bangs (!). It should
be...

Forms!FormName!FieldName
(two bangs)

Why do you have "Display" in there?
Click to expand...

Never mind. I see now that I was the one with the erroneous !Display in there.
I have no idea where that came from. Anyway if you entered your reference
correctly into the immediate window then you should get your value.
 
Der....

Thanks for the help, 30mins away from PC does wonders

Looks like the problem was that as I experimented and changed my query
I did not close it, which caused errors when I tested my form.

If I played with the query, closed it, then tested the form I got the
results I was after

Thanks for the help ......

If all else fails, go make a coffee
 
Back
Top