Not sure how to achive this...

[Corey-g via AccessMonster.com]

Hi All,

I have a main form (currently loads after login, but will be launched from a
switchboard later), which has a Tab Control in the detail section. On the
first page of the TC i have a form for order entry. All of the Order Info is
in the detail sect. of this (sub)form, and a subform for ordered items in the
footer.

I have the following table structure:

tblOrderInfo
Order_ID
Date_Submitted
Address
Order_Status_ID
etc...

tblOrder_Item
Item_ID
Order_ID
Part_Number
etc...

tblOrder_Status -- track status changes
Order_Status_ID
Order_ID
Status_ID
Status_Timestamp

tblStatus -- Limit list of possible status's
Status_ID
Status_Description

There is plenty more, but for what I'm trying to figure out...

So I want to place a 'Status' field on my order entry form that is not
changable by the user per-se. I had wanted to 'show' the status as Tentative
until the order was actually committed, then change the status to Ordered. I
had wanted to use a text box, but I don't think it is possible due to the
structure I have above. So I am thinking that i will need to use a combo box,
but still i don't know how to have this bound to the other table
'tblOrder_Status' (only one record source for a form).

Any thoughts would be appreciated,

Corey

 

[Guest]

I Think perhaps you need to post some coding atempts you have tried to better
clarify what you want to acheive, from what I read you just need a combobox
with the rowdsource bound to your table tblOrder_Status, perhaps with a
default value set to 'Tentative', but this sounds way too simple an answer to
your post, so more info please

TonyT..

 

[Corey-g via AccessMonster.com]

Thanks for responding Tony, I'll try to better describe the issue...

One thing I just noticed is that I typed in a field in the tblOrderInfo that
isn't correct - the Order_Status_ID - I don't actually relate the data that
way - but rather in the Order Status table (by Order_ID) so that one can see
all of the status' the order has had and when. So that might help to clear
up some of the confusion...

Because I don't have a status field in the Order Info table, I'm unsure of
how to implement. What I'm currently working through is having another
subform with the forms recordsource set to the Order_Status table, and the
combo box's Control source equal to the status ID. Then the rowsource of the
cbo is set to a query that will list the possible status'. Only thing is
that the form doesn't show up correctly - as in the combo box isn't showing -
only the outline of the subform.

Tony said I could just have a cbo and have the rowsource bound to the
Order_Status table - and maybe that is the key, but because the form's
recordsource doesn't include anything about the status I didn't see how this
could work.

TonyT wrote:

from what I read you just need a combobox
with the rowdsource bound to your table tblOrder_Status, perhaps with a
default value set to 'Tentative', but this sounds way too simple an answer to

your post, so more info please

 

[Guest]

If your combobox with the possible Status' in is unbound, then you can set
the rowsource to anything you like, however you will have to code the
After_update event to change the underlying table if it is changed.

TonyT..