Basic Questions

[don]

Hi,

I've two questions that I'm sure I should know but don't.

1) I have a number of subforms that contain records which when a new
record is entered I want to go onto a linked form which will contain
some of the data I've just entered. I have a command button to link
both forms but the bit I don't know is how to get the record out of
edit mode without manually selecting a record and then reselecting
before selecting my command button.

2) I use a query to enter an order amount, description, price and
calculated total, when I enter the order amount ie 2 and press tab a
zero appears to make my order amount 20, why?

Many thanks in anticipation

DonH

 

[Tom Wickerath]

Hi Don,

On question # 1, if I understand you correctly (?), try inserting the
following near the top of the Click event procedure for your command button:

If Me.Dirty = True Then 'Save the record
Me.Dirty = False
End If

On question # 2, see if you get the same result by creating a form based on
your query. You can use a default mode of Datasheet, which will have
essentially the same look and feel as a query.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[don]

Hi Don,

On question # 1, if I understand you correctly (?), try inserting the
following near the top of the Click event procedure for your command button:

   If Me.Dirty = True Then  'Save the record
       Me.Dirty = False
   End If

On question # 2, see if you get the same result by creating a form based on
your query. You can use a default mode of Datasheet, which will have
essentially the same look and feel as a query.

Tom Wickerath
Microsoft Access MVPhttp://www.accessmvp.com/TWickerath/
__________________________________________

Tom,

Thank you very much both suggestions worked fine. I have two more
questions

1) On my first question 2, I didn't explain fully enough and should of
said that my query is in a sub form and was until your suggestion set
as continuos form. When I went into the form design view to change
the sub form to datasheet the sub form was white and not editable. I
have come across this before but switching back to form and back to
design normally clears this, this time it wont and the only way I can
edit the subform is by opening it directly, can you give me a reason
why this might be.

2) All help the help sites I've seen cover how to do tasks never these
sort of issues am I looking in the wrong place? or do I have to rely
on the kindness of someone in a group.


Many thanks for your help, you put and end to a days head scratching,
shame it was a Sunday.

DonH

 

[Tom Wickerath]

Hi Don,

I have also seen this issue where a subform appears as a white rectangle in
form design view. I do not know the cause. However, you can still open the
form in design view by right-clicking at the edge of the subform. You should
see an option to open in new window.

I don't really know how to answer your second question, other than to say
we're here and ready to try to offer help.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[don]

Hi Don,

I have also seen this issue where a subform appears as a white rectangle in
form design view. I do not know the cause. However, you can still open the
form in design view by right-clicking at the edge of the subform. You should
see an option to open in new window.

I don't really know how to answer your second question, other than to say
we're here and ready to try to offer help.

Tom Wickerath
Microsoft Access MVPhttp://www.accessmvp.com/TWickerath/
__________________________________________

Thanks Tom