Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open new record with selected fields from previous record
I have a form that includes about 15 fields of information. There is a
search that locates previous records based on an Auto Number field (called ID). The search results are displayed on the form. I am trying to create a button that will open the form to a new record which will have 3 of the fields filled in based on the search results. I have created a query that will give the results but it has been a while since I worked in Access and I can't remember how to link to query to the opening of a new record. OR do I need to write the SQL directly in the button coding and if so can you get me started on the coding). Again it has been a while since working with Access, but I used to know how to do this stuff! Thanks for any assistance. Sue |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open new record with selected fields from previous record
OOPS - posted to wrong board - please disregard!
Sue "Design by Sue" wrote: I have a form that includes about 15 fields of information. There is a search that locates previous records based on an Auto Number field (called ID). The search results are displayed on the form. I am trying to create a button that will open the form to a new record which will have 3 of the fields filled in based on the search results. I have created a query that will give the results but it has been a while since I worked in Access and I can't remember how to link to query to the opening of a new record. OR do I need to write the SQL directly in the button coding and if so can you get me started on the coding). Again it has been a while since working with Access, but I used to know how to do this stuff! Thanks for any assistance. Sue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open form to specific record quits working | New Users to Excel | |||
hidden sheet to record open of file | Excel Discussion (Misc queries) | |||
Fields in a record are on the next line | Excel Discussion (Misc queries) | |||
flip spreadsheet data from row records to column record fields | Excel Discussion (Misc queries) | |||
flip spreadsheet data from row records to column record fields | Excel Discussion (Misc queries) |