Setting default value to controls based on previous form.

[DanWall]

Good afternoon.

I have a form, which is bound to a table. (frmDeliveries / tblDeliveries)
There is another table called tblItems with a [Delivery] field, which is linked to the tblDeliveries.[ID] field.

The problem I'm having is this....

As I'm entering a new field in the Deliveries form, there is a button that opens a dialog form containing the Items (Requires separate form due to various requirements).

I really need to default the combobox that relates to the [Delivery] field to default to whatever the delivery was that the user came from.

Is this possible?

I am trying to avoid VB if possible, so I am hoping to just use the Macro builder.

Thanks in advance.

 

[ajetrumpet]

I am just wondering if the attachment helps here...

 

[HiTechCoach]

I am just wondering if the attachment helps here...

Adam,

the OP said:

As I'm entering a new field in the Deliveries form, there is a button that opens a dialog form containing the Items (Requires separate form due to various requirements).

I really need to default the combobox that relates to the [Delivery] field to default to whatever the delivery was that the user came from.

I took this as needing to pass a value between forms not a new record in the same form.

Unfortunately, the OP wants to use a Macro and not VBA. It may be possible with a Macro, but since I never use them, I do not have a clue where to start. So I have not attempted to provide a solution that is not VBA. With VBA it would be very simple to do.

 

[ajetrumpet]

sorry boyd.

 

[DanWall]

Thanks very much for your attempts guys.
I really appreciate the effort.

Boyd, you are correct, I need to pass information to a new field.
I'm still playing around with it, but I think I've nearly found a solution.

I'll post it for you to see once I've done it...

Thanks again.

Dan.