RobertBeers
New Member
Hi there,
I am currently gearing up a database which makes use of several tabs. the RFI RFP database is filled using a userform which copies the data from the form to the database when the add button is clicked.
the thing I want to add is the following:
When the add button is clicked the SE TL TP database should also be filled with data based on data from the RFI RFP database and copied down based on a number value from the userform.
For instance when on the userform a line item amount of 3 is entered then the SE TL TP database should be filled with 3 rows with a TL TP# based on the AIB ID# +-number where the -number is based on the line item amount
Example:
AIB # = SA25RFI0087, then TL TP# should be SA25RFI0087-1, etc.
I am unable to upload the current file which has the code for the userform in it due to size restrcition. I have added en example workbook showing the outcome i desire.
Robert Beers
I am currently gearing up a database which makes use of several tabs. the RFI RFP database is filled using a userform which copies the data from the form to the database when the add button is clicked.
the thing I want to add is the following:
When the add button is clicked the SE TL TP database should also be filled with data based on data from the RFI RFP database and copied down based on a number value from the userform.
For instance when on the userform a line item amount of 3 is entered then the SE TL TP database should be filled with 3 rows with a TL TP# based on the AIB ID# +-number where the -number is based on the line item amount
Example:
AIB # = SA25RFI0087, then TL TP# should be SA25RFI0087-1, etc.
I am unable to upload the current file which has the code for the userform in it due to size restrcition. I have added en example workbook showing the outcome i desire.
Robert Beers
Last edited:
