I am trying to create a form that has a predictive field that Automatically predicts and completes the name that I am typing, and when I press tab the remaining Address and Postcode fields are automatically completed. All of this information is taken from one table as a source and is to be compiled into another separate table.
The problem I am having is that I can create a predictive field that completes what I type, I can also create VBA that will auto fill the remaining address and postcode fields automatically but I can not make both of these things work together. It seems I must have one or the other. (I must completely type the whole name and press tab to have the Address field and postcode field fill automatically or have the predictive field complete the name I type and enter the Address and Postcode Manually.
My question is
Why will they not work together?
Is there a way around this Problem?