Create PopUp Form for Additional Details

[hullstorage]

Hi all
Can somebody tell me how to create a popup form for additional
data entry.

What i need is when entering data on the on exit event of the address field to show a form to enter the quantity, weight and service details

I think i may need to create a seperate table with a relationship as the fields are currently in the main table as below

Tbl1
Date
Customer
Address
(I want the fields below to show in a popup form)
NoItems
Weight
Service

I have got this working at the minute but because the record is still being edited this simply creates a new record when the popup opens

 

[matthewnsarah07]

Hi

Seems you have two options

As you say you could setup a new table with a realtionship with tbl1 i.e. [CustomerID], then get the popup to open on exit, filtering by that field.

Or a quick possibly not so good way would be to have your on exit event open the popup as does now then close your main form - I have done this in the past an it does work

 

[hullstorage]

Hi

Seems you have two options

As you say you could setup a new table with a realtionship with tbl1 i.e. [CustomerID], then get the popup to open on exit, filtering by that field.

Or a quick possibly not so good way would be to have your on exit event open the popup as does now then close your main form - I have done this in the past an it does work

I have created a reltionship now, is this correct below
and how do i associate the popup with the current record been added

TblDelivery
DeliveryID
Date
Customer
Address ( popup opens on exit )
CustomerRef
Cost

TblDescription
DeliveryID
NoItems
Weight
Service
On exit now return to CustomerRef

 

[matthewnsarah07]

I'm assuming that [DeliveryID] is the primary key in each table, in tblDescription create a primary key such as [DescriptionID] then create the relationship between the two [DeliveryID] fields.

If you just use the command button wizard to create a button to open the popup based in the DeliveryID's mathcing then when there is no match you will simply get a blank for you can enter your additional data into and manually enter the DeliveryID into the popup - the next time it will open to this record.

If you want to add the deliveryID quicker on the popup then setup a blank command button and add something

Me.DeliveryID = Forms!yourform!DeliveryID

, and that will insert it for you