Transferring from forms and lookups

[diasflac]

Hi again,

I have two forms. "ViewRFQ" and "Quote". On the "ViewRFQ" Form, when a user selects the RFQ Reference Number it will bring up the already created RFQ record. The user can then click a command button called "Quote" this asks whether a quote has been received and changes the status, it also opens the "Quote" Form.

Quote - is linked to a table called Quote.

I would like 2 of the fields to be filled in from the "ViewRFQ" Form - "RFQ Reference Number" and "RFQ Title" and these fields saved in the same titled fields in the Quote table.

In the event this RFQ Title and reference number already have a quote when clicking this button, I would like it to bring up the record from the ViewRFQ Form so the data can be edited.

I've run into problems as the RFQ reference number isn't already in the quote table.

I have attached the database if someone could help.

 

[jdraw]

You may find this model helpful, or maybe not. It generalizes various details up to a Statement entity; and each detail is related by StatementType.

Good luck with your project.

 

[diasflac]

You may find this model helpful, or maybe not. It generalizes various details up to a Statement entity; and each detail is related by StatementType.

Good luck with your project.

Thanks.

I need the details transferred to the text boxes, this works so far however when you click quote from a record that doesn't yet exist it just brings up a previous record. :banghead:

If you use the switchboard on my database and go into View RFQ then pick an RFQ reference number, then click quote. You can see what I mean, because regardless of reference number you choose it only brings up record Ref: 33, as it's the only record in the Quote table. :banghead:

If a record exists for that RFQ Reference number and RFQ title, I need it to bring up the details existing in the table, if not, I would like it to create a blank with the Reference number and Title put in already.

 

[diasflac]

Bump - Any help at all would be great!

 

[diasflac]

Bump - Again

 

[Pat Hartman]

The only field you need to copy is the foreign key which should be the RFQReferenceNum.

In the BeforeInsert event of the Quote form

Me.RFQReferenceNum = Forms!theRFQform!RFQReferenceNum